Mostly ANSI-compliant SQL with analytical extensions.
SELECT
→ SELECT, SELECT DISTINCT, SELECT DISTINCT ON
WHERE
→ Filter rows based on conditions
TIMESTAMP AS OF
→ Time travel queries (table version as of given
timestamp)
VERSION AS OF
→ Time travel by snapshot id, or VERSION AS OF PREVIOUS
for the version before the current one
JOIN
→ INNER, LEFT, RIGHT, CROSS, LEFT SEMI, LEFT ANTI
GROUP BY → Group rows by columns
HAVING → Filter grouped results
ORDER BY → ORDER BY column ASC|DESC
LIMIT → Limit number of rows returned
OFFSET → Skip specified number of rows
UNION
→ UNION, UNION ALL to combine query results
Loading functions…
Loading operators…