Grammar
Browse railroad diagrams for any dialect. Every SQL construct is defined once, with dialect predicates picking the variants. Pick a dialect to start exploring.
SQL dialects
AlloyDB
3,006 rules · via PostgreSQL
Amazon Athena
1,667 rules
Amazon Redshift
1,932 rules
ANSI SQL
1,455 rules
Apache Doris
2,658 rules
Apache Hive
2,039 rules
Apache Impala
1,765 rules
Aurora MySQL
2,243 rules · via MySQL
Aurora PostgreSQL
3,006 rules · via PostgreSQL
Azure SQL
2,974 rules · via T-SQL
Azure Synapse
2,988 rules
BigQuery
2,204 rules
chDB
2,555 rules · via ClickHouse
Citus
3,006 rules · via PostgreSQL
ClickHouse
2,555 rules
Cloud Spanner
2,239 rules
CockroachDB
3,619 rules
Databricks SQL
1,871 rules
DuckDB
2,140 rules
DuneSQL
1,589 rules
IBM DB2
3,086 rules
MariaDB
2,298 rules
Microsoft Fabric
2,991 rules
MotherDuck
2,154 rules
MySQL
2,243 rules
Neon
3,006 rules · via PostgreSQL
Oracle
3,391 rules
PlanetScale
2,277 rules
PostgreSQL
3,006 rules
Presto
1,603 rules
SingleStore
2,258 rules
Snowflake
2,471 rules
Spanner PostgreSQL
3,006 rules · via PostgreSQL
Spark SQL
1,767 rules
SQLite
1,287 rules
Starburst
1,596 rules
StarRocks
2,668 rules
Supabase
3,006 rules · via PostgreSQL
T-SQL
2,974 rules
TiDB
2,459 rules
TimescaleDB
3,006 rules · via PostgreSQL
Trino
1,617 rules
YugabyteDB
3,019 rules
Query languages
The same grammar toolchain also parses non-SQL query languages. These are a separate group, not counted among the SQL dialects.