Supported databases
Databases and versions with tailored SQL.
| Database | Versions |
|---|---|
| PostgreSQL | 18, 17, 16, 15, 14 |
| MySQL | 9.x, 8.4 LTS |
| MariaDB | 11.8, 11.4, 10.11 |
| SQL Server | 2025, 2022, 2019, 2017, Azure SQL |
| Oracle | 26ai, 19c |
| SQLite | 3 |
| Snowflake | current |
| Anything else | via Other database… (AI profile) |
SQL is tailored to each version, for example: Oracle 26ai uses native BOOLEAN and JSON, while 19c uses NUMBER(1) and CLOB; SQL Server 2025 and Azure SQL use native JSON; MariaDB uses its native UUID type. Identifier quoting, date/timestamp literals, BLOB literals and insert batch sizes (1,000 rows for SQL Server, one row per statement for Oracle, 500 elsewhere) are handled for you.