Data selection statements in Drifto should be of this general form: SELECT <COLUMNS> FROM <TABLE> JOIN <TABLE> ON <COLUMN> WHERE <CLAUSE> GROUP BY <COLUMNS> HAVING <CLAUSE> ORDER BY <COLUMNS> LIMIT <INT>; While Drifto aims to support all standard SQL, many warehouses and query engines come with additional or special operations or commands that Drifto can not support. Concretely, this means that you cannot use both a Drifto-specific operation or function in the same command that uses an operation or function that is particular to your platform. The usual workaround is to just split the query up into two or more sequential queries with materializtions in between as necessary.