Dialects¶

Sqruff currently supports the following SQL dialects:

Dialects Index¶

• ansi
• athena
• bigquery
• clickhouse
• databricks
• duckdb
• mysql
• postgres
• redshift
• snowflake
• sparksql
• sqlite
• trino
• tsql

Details¶

ansi¶

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

Configuration:

[sqruff:dialect:ansi]

athena¶

Amazon Athena SQL dialect for querying data in S3.

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.

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

Configuration:

[sqruff:dialect:bigquery]

clickhouse¶

ClickHouse SQL dialect for real-time analytics.

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]

duckdb¶

DuckDB SQL dialect for in-process analytical database.

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

Configuration:

[sqruff:dialect:duckdb]

mysql¶

MySQL SQL dialect for the popular open-source database.

Documentation: https://dev.mysql.com/doc/

Configuration:

[sqruff:dialect:mysql]

postgres¶

PostgreSQL SQL dialect for the advanced open-source database.

Documentation: https://www.postgresql.org/docs/current/sql.html

Configuration:

[sqruff:dialect:postgres]

redshift¶

Amazon Redshift SQL dialect for cloud data warehousing.

Documentation: https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_SQLCommandRef.html

Configuration:

[sqruff:dialect:redshift]

snowflake¶

Snowflake SQL dialect for cloud data platform.

Documentation: https://docs.snowflake.com/en/sql-reference.html

Configuration:

[sqruff:dialect:snowflake]

sparksql¶

Apache Spark SQL dialect for big data processing.

Documentation: https://spark.apache.org/sql/

Configuration:

[sqruff:dialect:sparksql]

sqlite¶

SQLite SQL dialect for embedded database.

Documentation: https://www.sqlite.org/lang.html

Configuration:

[sqruff:dialect:sqlite]

trino¶

Trino (formerly PrestoSQL) dialect for distributed SQL queries.

Documentation: https://trino.io/docs/current/sql.html

Configuration:

[sqruff:dialect:trino]

tsql¶

T-SQL dialect for Microsoft SQL Server and Azure SQL.

Documentation: https://learn.microsoft.com/en-us/sql/t-sql/language-reference

Configuration:

[sqruff:dialect:tsql]

We are working on adding support for more dialects in the future.