End-User Documentation

Database Type Validation

Database Type Validation

This stage adds database-specific validation. QueryLens validates SQL functions, reserved words, and syntax rules against a specific database family and version.

What You Get

  • Database-specific syntax validation
  • Built-in function validation
  • Version-aware function checks
  • Reserved-word checks

Minimal Example

QueryLens.Dialect = DialectProfile.SqlServer2019;

var query = new SqlQuery("SELECT STRING_AGG(name, ',') FROM dbo.departments");
Assert.True(query.IsValid);

Why This Matters

At basic syntax validation, a query may pass because generic mode is permissive. With database-type-sensitive validation, the same query is checked against a real target engine.

QueryLens.Reset();
QueryLens.Dialect = DialectProfile.Sqlite3;

var query = new SqlQuery("SELECT TOP 10 name FROM customers");
Assert.False(query.IsValid);

Supported Databases

  • SQL Server
  • PostgreSQL
  • MySQL
  • SQLite
  • Oracle

Related