Supported SQL Scope and Current Limits
QueryLens is designed to validate hand-written SQL used in test suites and query registries, not to model every capability of every database engine.
What It Validates Best
- Common query, insert, update, delete, merge, and stored procedure patterns
- Dialect-aware syntax and built-in functions
- Schema-backed object existence and write restrictions when a snapshot is loaded
Intentional Limits
- Generic mode is intentionally permissive.
- Not every database engine capability is modeled in depth.
- Schema loading is currently limited to SQL Server-backed loading.
- Integration tests are still necessary for execution plans, permissions, data-dependent behavior, and provider-specific runtime details.
Example
var query = new SqlQuery("SELECT * FROM customers");
Assert.True(query.IsValid);