SQL Dialects
SQLFluff supports 28 SQL dialects.
Supported Dialects
| Dialect | Label | Inherits From |
|---|---|---|
| ANSI | ansi | - |
| AWS Athena | athena | ansi |
| Google BigQuery | bigquery | ansi |
| ClickHouse | clickhouse | ansi |
| Databricks | databricks | sparksql |
| IBM Db2 | db2 | ansi |
| Apache Doris | doris | mysql |
| DuckDB | duckdb | postgres |
| Exasol | exasol | ansi |
| Apache Flink SQL | flink | ansi |
| Greenplum | greenplum | postgres |
| Apache Hive | hive | ansi |
| Apache Impala | impala | hive |
| MariaDB | mariadb | mysql |
| Materialize | materialize | postgres |
| MySQL | mysql | ansi |
| Oracle | oracle | ansi |
| PostgreSQL | postgres | ansi |
| AWS Redshift | redshift | postgres |
| Snowflake | snowflake | ansi |
| Salesforce Object Query Language (SOQL) | soql | ansi |
| Apache Spark SQL | sparksql | ansi |
| SQLite | sqlite | ansi |
| StarRocks | starrocks | mysql |
| Teradata | teradata | ansi |
| Trino | trino | ansi |
| Microsoft T-SQL | tsql | ansi |
| Vertica | vertica | ansi |