Skip to main content
Query Engine runs standard ANSI SQL. This reference covers what’s specific to Query Engine: the data types it supports, every function with its syntax and examples, the few statements and clauses that go beyond plain SELECT, and how functions from other engines map to e6data.

Supported data types

Which types you can query and how to write literals for them.

SQL functions

Every function, grouped by category, with syntax, arguments, return values and examples.

Statements and clauses

COPY INTO, GROUPING SETS, ROLLUP, CUBE and SELECT * EXCEPT.

Equivalent functions and operators

Coming from Athena, BigQuery, Databricks, Presto, Redshift or Snowflake? Find the e6data equivalent.

​
Browse functions by category

Everyday SQL: Semi-structured data: Pattern matching, hashing and bits: Specialised: Geospatial
Last modified on October 16, 2026