language.md

language

Specifies the SQL dialect to use.

Options

• "sql" - (default) Standard SQL
• "bigquery" - GCP BigQuery
• "db2" - IBM DB2
• "hive" - Apache Hive
• "mariadb" - MariaDB
• "mysql" - MySQL
• "n1ql" - Couchbase N1QL
• "plsql" - Oracle PL/SQL
• "postgresql" - PostgreSQL
• "redshift" - Amazon Redshift
• "spark" - Spark
• "sqlite" - SQLite
• "tsql" - SQL Server Transact-SQL

The default "sql" dialect is meant for cases where you don't know which dialect of SQL you're about to format. It's not an auto-detection, it just supports a subset of features common enough in many SQL implementations. This might or might not work for your specific dialect. Better to always pick something more specific if possible.