SQL language

SEP uses the Trino SQL query engine that allows users to use standard SQL, and use their favorite data tools, including BI and ETL tools, with any underlying data source.

This section provides an overview of SQL support, a reference to the supported SQL data types and other general characteristics of the SQL support in SEP.

A complete SQL statement and syntax referenceand documentation on numerous SQL functions and operators are available in separate sections.

• SQL statement support
  • Globally available statements
  • Read operations
  • Write operations
  • Security operations
  • Transactions
• Data types
  • Trino type support and mapping
  • Boolean
  • Integer
  • Floating-point
  • Fixed-precision
  • String
  • Date and time
  • Structural
  • Network address
  • UUID
  • HyperLogLog
  • SetDigest
  • Quantile digest
  • T-Digest
• Reserved keywords