How misc. columns in SQL

[Das Goravani]

Hello,

Sometimes when doing SQL columns are generated by the SQL statement. Not always do the columns find presence in the schema class. 

I am only familiar with doing SQL with a SQL list that is defined from a schema, table or query class. Thus the list contains only columns that are defined in some schema in Omnis. 

How do you do SQL while returning made up columns from your SQL statement?

Do you do the SQL without a list.. 

And then fetch into a blank list and it puts the columns there?

Thanks,

Das