Dialects¶

Sqruff currently supports the following SQL dialects:

Each dialect includes a collapsed list of segment types generated from its reachable grammar and lexer using the default dialect configuration. Use these names in [sqruff:layout:type:<type>] configuration section headings. Some types are internal or meta segments; run sqruff parse query.sql --dialect <dialect> to inspect the concrete syntax tree for a particular query.

Dialects Index¶

• ansi
• athena
• bigquery
• clickhouse
• databricks
• db2
• doris
• duckdb
• exasol
• flink
• greenplum
• hive
• impala
• mariadb
• materialize
• mysql
• oracle
• postgres
• redshift
• snowflake
• sparksql
• sqlite
• starrocks
• teradata
• trino
• tsql
• vertica

Details¶

ansi¶

Standard SQL syntax. The default dialect and base for all others.

Default Casing: UPPERCASE

Quotes: String literals: ''; identifiers: "".

Configuration:

[sqruff:dialect:ansi]

athena¶

Amazon Athena SQL dialect for querying data in S3.

Default Casing: lowercase

Quotes: String literals: '', "", or backticks; identifiers: "" or backticks.

Documentation: https://docs.aws.amazon.com/athena/latest/ug/ddl-sql-reference.html

Configuration:

[sqruff:dialect:athena]

bigquery¶

Google BigQuery SQL dialect for analytics and data warehousing.

Default Casing: BigQuery resolves unquoted column identifiers case-insensitively, and table and dataset identifiers case-sensitively by default. Columns retain the case used by each reference in result-set labels.

Quotes: String literals: '', "", @, or @@; quoted strings also support r/R raw or regex prefixes and b/B byte-string prefixes. Identifiers: "" or backticks.

Documentation: https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax

Configuration:

[sqruff:dialect:bigquery]

clickhouse¶

ClickHouse SQL dialect for real-time analytics.

Default Casing: ClickHouse is case-sensitive throughout, regardless of quoting. An unquoted reference using the wrong case raises an UNKNOWN_IDENTIFIER error.

Quotes: String literals: ''; identifiers: "" or backticks. Because identifiers are always resolved case-sensitively, quoting is only needed for invalid characters or reserved keywords.

Documentation: https://clickhouse.com/docs/en/sql-reference/

Configuration:

[sqruff:dialect:clickhouse]

databricks¶

Databricks SQL dialect for lakehouse analytics.

Documentation: https://docs.databricks.com/en/sql/language-manual/index.html

Configuration:

[sqruff:dialect:databricks]

db2¶

IBM Db2 SQL dialect.

Documentation: https://www.ibm.com/docs/en/i/7.4?topic=overview-db2-i

Configuration:

[sqruff:dialect:db2]

doris¶

Apache Doris SQL dialect, based on MySQL.

Default Casing: lowercase

Quotes: String literals: '', ""; identifiers: backticks.

Documentation: https://doris.apache.org/

Configuration:

[sqruff:dialect:doris]

duckdb¶

DuckDB SQL dialect for in-process analytical database.

Default Casing: DuckDB stores all identifiers in the case they were defined, but resolves both quoted and unquoted identifiers case-insensitively. See the DuckDB identifiers documentation.

Quotes: String literals: ''; identifiers: "" or ''.

Documentation: https://duckdb.org/docs/sql/introduction

Configuration:

[sqruff:dialect:duckdb]

exasol¶

Exasol SQL dialect for the Exasol analytics database.

Documentation: https://docs.exasol.com/db/latest/sql_references.htm

Configuration:

[sqruff:dialect:exasol]

flink¶

Apache Flink SQL dialect for stream processing and table operations.

Default Casing: Case insensitive for quoted and unquoted identifiers.

Quotes: String literals: single quotes; identifiers: backticks.

Documentation: https://nightlies.apache.org/flink/flink-docs-release-1.18/docs/dev/table/sql/

Configuration:

[sqruff:dialect:flink]

greenplum¶

Greenplum SQL dialect, a massively parallel Postgres.

Documentation: https://docs.vmware.com/en/VMware-Greenplum/index.html

Configuration:

[sqruff:dialect:greenplum]

hive¶

Apache Hive SQL dialect for data warehousing.

Documentation: https://hive.apache.org/docs/latest/language/

Configuration:

[sqruff:dialect:hive]

impala¶

Apache Impala SQL dialect for distributed SQL queries.

Documentation: https://impala.apache.org/docs/build/html/topics/impala_langref.html

Configuration:

[sqruff:dialect:impala]

mariadb¶

MariaDB SQL dialect, a community-developed fork of MySQL.

Default Casing: lowercase

Quotes: String literals: '', "", or @; identifiers: backticks.

Documentation: https://mariadb.com/kb/en/sql-statements-structure/

Configuration:

[sqruff:dialect:mariadb]

materialize¶

Materialize SQL dialect for the streaming data warehouse.

Documentation: https://materialize.com/docs/sql/

Configuration:

[sqruff:dialect:materialize]