Alternative Query Languages

Besides standard SQL, ClickHouse supports various alternative query languages for querying data.

The currently supported dialects are:

• clickhouse: The default SQL dialect of ClickHouse
• prql: Pipelined Relational Query Language (PRQL)
• kusto: Kusto Query Language (KQL)

Which query language is used is controlled by setting dialect.

Standard SQL

Standard SQL is the default query language of ClickHouse.

Pipelined Relational Query Language (PRQL)

Experimental feature. Learn more.

To enable PRQL:

Example PRQL query:

Under the hood, ClickHouse uses transpilation from PRQL to SQL to run PRQL queries.

Kusto Query Language (KQL)

Experimental feature. Learn more.

To enable KQL:

Example KQL query:

Result:

Note that KQL queries may not be able to access all functions defined in ClickHouse.