> ## Documentation Index
> Fetch the complete documentation index at: https://dune-tables-docs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/query-engine/Functions-and-operators/varbinary)
* [Base58](/query-engine/Functions-and-operators/base58)
* [Chain Utility Functions](/query-engine/Functions-and-operators/chain-utility-functions)
* [Varchar Utility Functions](/query-engine/Functions-and-operators/varchar-utility-functions)

### Trino Base Functions:

* [Aggregate](query-engine/Functions-and-operators/aggregate)
* [Array](/query-engine/Functions-and-operators/array)
* [Binary](/query-engine/Functions-and-operators/binary)
* [Bitwise](/query-engine/Functions-and-operators/bitwise)
* [Comparison](/query-engine/Functions-and-operators/comparison)
* [Conditional](/query-engine/Functions-and-operators/conditional)
* [Conversion](/query-engine/Functions-and-operators/conversion)
* [Date and time](/query-engine/Functions-and-operators/datetime)
* [Decimal](/query-engine/Functions-and-operators/decimal)
* [HyperLogLog](/query-engine/Functions-and-operators/hyperloglog)
* json file currently not available
* [Lambda](/query-engine/Functions-and-operators/lambda)
* [Logical](/query-engine/Functions-and-operators/logical)
* [Map](/query-engine/Functions-and-operators/map)
* [Math](/query-engine/Functions-and-operators/math)
* [Quantile digest](/query-engine/Functions-and-operators/qdigest)
* [Regular expression](/query-engine/Functions-and-operators/regexp)
* [Set Digest](/query-engine/Functions-and-operators/setdigest)
* [String](/query-engine/Functions-and-operators/string)
* [System](/query-engine/Functions-and-operators/system)
* [Teradata](/query-engine/Functions-and-operators/teradata)
* [T-Digest](/query-engine/Functions-and-operators/tdigest)
* [URL](/query-engine/Functions-and-operators/url)
* [UUID](/query-engine/Functions-and-operators/uuid)
* [Window](/query-engine/Functions-and-operators/window)