Table of Contents

Supported databases and versions

Supported versions

Database Server versions supported Server versions tested Driver package Driver versions supported Driver versions tested dialect Pages
PostgreSQL 14 or later 14, 15, 16, 17, 18 Npgsql 8 or later 8, 10 postgres PostgreSQL
SQL Server 2017 or later 2017, 2019, 2022, 2025 Microsoft.Data.SqlClient 6.1 or later 6.1, 7 mssql SQL Server

The tool describes the queries of these two databases, and of Azure SQL, and of no other. Database support lists the other databases.

Database support

Database Dialect Can be described Page
PostgreSQL postgres Yes PostgreSQL
SQL Server, Azure SQL mssql Yes SQL Server
MySQL mysql No None
MariaDB mariadb No None
SQLite sqlite No None
Oracle oracle No None
CockroachDB cockroachdb No None
Any other database ansi No None

SqlSource reads the queries of every dialect. Whatever the database, the queries of every .sql file whose output is models or sql get their constants and token methods. Described is more: the sqlsource tool asks the database about the parameters and columns of a query, and writes the answer to a sidecar. The tool goes by the dialect of the file, and asks only the databases marked Yes. Azure SQL can be described, and is accepted, and not tested: see Azure SQL.

Azure SQL

Azure SQL Database and Azure SQL Managed Instance are accepted, and not tested. The tool accepts each of them whatever version it reports, and never reports SQLSRC235 for either of them.