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
DialectValue
PostgreSQLpostgres
MySQLmysql
BigQuerybigquery
T-SQL (SQL Server)tsql
Snowflakesnowflake
Databricksdatabricks
Oracleoracle
SQLitesqlite
MariaDBmariadb
Apache Hivehive

Coming Soon

The following dialects are planned for upcoming releases.

RedshiftDuckDBSparkSpark2TrinoPrestoClickHouseAthenaStarRocksTeradataDruidDrillDremioExasolRisingWaveMaterializeFabricDuneSolrPRQLTableauDoris