- “Explain Select”
- “Drop Table” and “Create Table As”
- “Drop View” and “Create View”
For each variable, a select list item is generated for the variable expression. If requested as expert options, WHERE, QUALIFY, HAVING, GROUP BY, ORDER BY, SAMPLE, TOP, WITH (RECURSIVE) and EXPAND ON clauses may be generated. In the FROM clause, data is selected from the anchor table, and left outer joined to any other tables referred to in the variable, dimension or expert clause definitions, including Table Functions and Table Operators. Aliases are generated for each table or view accessed and all column names are automatically qualified using these aliases.