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