Dialects and Version Profiles
A DialectProfile selects both a SQL dialect family and a target version so QueryLens can validate syntax, functions, and reserved words against the right engine behavior.
Why Versioned Profiles Exist
- A function or syntax feature may exist in one release and not in an earlier one.
- Reserved-word handling can differ across engines and versions.
- Choosing the right profile makes failures more closely match production behavior.
Supported Families
- Generic SQL
- SQL Server
- PostgreSQL
- MySQL
- SQLite
- Oracle
Important Note
Generic mode is intentionally permissive and works best for early adoption or cross-dialect query libraries.
Example
QueryLens.Dialect = DialectProfile.PostgreSql14;
var query = new SqlQuery("SELECT now()");
Assert.True(query.IsValid);