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.

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:

• Varbinary datatypes
• Base58
• ss58
• Tron Address Functions
• Chain Utility Functions
• Varchar Utility Functions

Trino Base Functions:

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