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,382 rules · via PostgreSQL
Amazon Athena
1,848 rules
Amazon Redshift
1,902 rules
ANSI SQL
1,540 rules
Apache Doris
3,108 rules
Apache Hive
2,129 rules
Apache Impala
2,064 rules
Aurora MySQL
2,584 rules · via MySQL
Aurora PostgreSQL
3,382 rules · via PostgreSQL
Azure SQL
3,655 rules · via T-SQL
Azure Synapse
3,656 rules
BigQuery
2,649 rules
chDB
2,667 rules · via ClickHouse
Citus
3,382 rules · via PostgreSQL
ClickHouse
2,667 rules
Cloud Spanner
2,693 rules
CockroachDB
3,709 rules
Databricks SQL
2,039 rules
DuckDB
2,362 rules
DuneSQL
1,768 rules
IBM DB2
3,476 rules
MariaDB
2,584 rules
Microsoft Fabric
3,656 rules
MotherDuck
2,376 rules
MySQL
2,584 rules
Neon
3,382 rules · via PostgreSQL
Oracle
3,743 rules
PlanetScale
2,613 rules
PostgreSQL
3,382 rules
Presto
1,771 rules
SingleStore
2,612 rules
Snowflake
2,637 rules
Spanner PostgreSQL
3,382 rules · via PostgreSQL
Spark SQL
1,912 rules
SQLite
1,532 rules
Starburst
1,773 rules
StarRocks
3,108 rules
Supabase
3,382 rules · via PostgreSQL
T-SQL
3,655 rules
TiDB
2,801 rules
TimescaleDB
3,382 rules · via PostgreSQL
Trino
1,766 rules
YugabyteDB
3,382 rules
Query languages
The same grammar toolchain also parses non-SQL query languages. These are a separate group, not counted among the SQL dialects.