Supported Dialects
Dialect tells SQLGuard how to parse the query. Detection rules apply the same way across all ten.
# MySQL — LIMIT syntax
{"sql": "SELECT * FROM users LIMIT 10", "dialect": "mysql"}
# → allowed: true
# T-SQL (SQL Server) — LIMIT syntax
{"sql": "SELECT TOP 10 * FROM users", "dialect": "tsql"}
# → allowed: true| Dialect | Value |
|---|---|
| PostgreSQL | postgres |
| MySQL | mysql |
| BigQuery | bigquery |
| T-SQL (SQL Server) | tsql |
| Snowflake | snowflake |
| Databricks | databricks |
| Oracle | oracle |
| SQLite | sqlite |
| MariaDB | mariadb |
| Apache Hive | hive |
Coming Soon
The following dialects are planned for upcoming releases.
RedshiftDuckDBSparkSpark2TrinoPrestoClickHouseAthenaStarRocksTeradataDruidDrillDremioExasolRisingWaveMaterializeFabricDuneSolrPRQLTableauDoris