SQL language

Trino is an ANSI SQL compliant query engine. This standard compliance allows Trino users to integrate their favorite data tools, including BI and ETL tools with any underlying data source.

Trino validates and translates the received SQL statements into the necessary operations on the connected data source.

This section provides a reference to the supported SQL data types and other general characteristics of the SQL support of Trino.

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
• Comments