End-User Documentation

Dialect Profiles

Dialect Profiles

QueryLens currently supports the following public DialectProfile values.

Generic

  • GenericSql

SQL Server

  • SqlServer2012
  • SqlServer2014
  • SqlServer2016
  • SqlServer2017
  • SqlServer2019
  • SqlServer2022

PostgreSQL

  • PostgreSql12
  • PostgreSql13
  • PostgreSql14

MySQL

  • MySql8

SQLite

  • Sqlite3

Oracle

  • Oracle12c
  • Oracle19c

Notes

  • Versioned profiles allow function and syntax checks to match the target engine more precisely.
  • Schema loading is currently SQL Server-backed.

Example

QueryLens.Dialect = DialectProfile.Oracle19c;
var query = new SqlQuery("SELECT employee_id FROM employees");
Assert.True(query.IsValid);

Related