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,542 rules · via PostgreSQL
Amazon Athena
1,862 rules
Amazon Redshift
1,917 rules
ANSI SQL
1,552 rules
Apache Doris
3,170 rules
Apache Hive
2,298 rules
Apache Impala
2,091 rules
Aurora MySQL
2,648 rules · via MySQL
Aurora PostgreSQL
3,542 rules · via PostgreSQL
Azure SQL
3,668 rules · via T-SQL
Azure Synapse
3,669 rules
BigQuery
2,640 rules
chDB
2,715 rules · via ClickHouse
Citus
3,542 rules · via PostgreSQL
ClickHouse
2,715 rules
Cloud Spanner
2,677 rules
CockroachDB
4,342 rules
Databricks SQL
2,055 rules
DuckDB
2,400 rules
DuneSQL
1,782 rules
IBM DB2
3,491 rules
MariaDB
2,648 rules
Microsoft Fabric
3,669 rules
MotherDuck
2,414 rules
MySQL
2,648 rules
Neon
3,542 rules · via PostgreSQL
Oracle
3,760 rules
PlanetScale
2,677 rules
PostgreSQL
3,542 rules
Presto
1,785 rules
SingleStore
2,676 rules
Snowflake
2,678 rules
Spanner PostgreSQL
3,542 rules · via PostgreSQL
Spark SQL
1,923 rules
SQLite
1,544 rules
Starburst
1,787 rules
StarRocks
3,172 rules
Supabase
3,542 rules · via PostgreSQL
T-SQL
3,668 rules
TiDB
2,900 rules
TimescaleDB
3,542 rules · via PostgreSQL
Trino
1,780 rules
YugabyteDB
3,572 rules
Query languages
The same grammar toolchain also parses non-SQL query languages. These are a separate group, not counted among the SQL dialects.