Skip to main content

Grammar

Browse the interactive grammar with railroad diagrams for any dialect. Every SQL construct is defined once with dialect predicates — click into a dialect to explore.

ANSI SQL
1,418 rules
BigQuery
2,621 rules
Databricks
1,951 rules
DB2
3,462 rules
DuckDB
2,291 rules
MariaDB
2,518 rules
Oracle
3,554 rules
PostgreSQL
3,312 rules
Presto
1,737 rules
Redshift
1,917 rules
Snowflake
2,512 rules
Spark SQL
1,828 rules
SQLite
1,509 rules
T-SQL
3,473 rules
Trino
1,743 rules