SQL language

You’ve come to the right place if you are looking for reference material on SQL in Starburst Enterprise platform (SEP). If you want in-depth training on handling complex data types and more, check out our advanced SQL video training. It covers topics such as: using JSON array and map functions advanced aggregations window functions

View the training

SEP uses the Trino SQL query engine that allows users to use standard SQL, and there user 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.

Refer to the following sections for further details:

• SQL statement and syntax reference

• SQL functions and operators

• SQL statement support
  • Globally available statements
  • Read operations
  • Write operations
  • Security operations
  • Transactions
• Data types
  • Trino type support and mapping
  • Boolean
  • Integer
  • Floating-point
  • Exact numeric
  • String
  • Date and time
  • Structural
  • Network address
  • UUID
  • HyperLogLog
  • SetDigest
  • Quantile digest
  • T-Digest
• Keywords and identifiers
  • Reserved keywords
  • Identifiers
• Comments
  • Synopsis
  • Examples
  • See also