...

The following limitations apply to creating datasets from a single statement. 

1. All single-statement SQL queries must begin with a SELECT keyword.

2. Selecting columns with the same name, even with "*", is not supported and generates an ambiguous column name error. 

   Tip
   Tip: You should use fully qualified column names or proper aliasing. See Column Aliasing below.

   
   

3. Users are encouraged to provide fully qualified path to table being used. Example:

   Code Block
   SELECT "id", "value" FROM "public"."my_table"

   
   

4. You should use proper escaping in SQL.

...