Overview

DuneSQL supports a wide range of built-in functions and operators.

This chapter describes the built-in SQL functions and operators supported by Trino. They allow you to implement complex functionality and behavior of the SQL executed by Trino operating on the underlying data sources.

Table procedures such as Datashare syncs are documented under Supported SQL Operations, not in this functions reference.

Using SHOW FUNCTIONS in the query editor returns a list of all available functions, including custom functions, with all supported arguments and a short description.

DuneSQL Added Functions and Operators:

• Varbinary datatypes for EVM data
• EIP-8021 calldata table function
• Base58 for Bitcoin&Solana data
• ss58 for Substrate data
• Tron Address Functions
• Chain Utility Functions
• Varchar Utility Functions
• LiveFetch Functions
• ASOF Join

Trino Base Functions:

• Aggregate
• Array
• Binary
• Bitwise
• Comparison
• Conditional
• Conversion
• Date and time
• Decimal
• HyperLogLog
• JSON
• Lambda
• Logical
• Map
• Math
• Quantile digest
• Regular expression
• Set Digest
• String
• System
• Teradata
• T-Digest
• URL
• UUID
• Window