QueryLens 1.1.3

QueryLens

Stop finding SQL bugs in production. Catch them in your tests.

Column typos. Misspelled table names. Functions that don't exist in your SQL Server version. Parameter mismatches. These bugs hide in raw SQL strings, slip past the compiler, and blow up at runtime — usually in production, usually at the worst time.

QueryLens validates your hand-written SQL at test time, giving Dapper, ADO.NET, and query-registry codebases a real validation surface — without an ORM, without generated code, without changing how you write SQL.

Get Started in 30 Seconds

dotnet add package QueryLens

var query = new SqlQuery("SELECT name FROM customers LIMIT 10");

Assert.True(query.IsValid);   // structurally sound SQL — validated, done

That's it. No configuration, no database connection, no ceremony. QueryLens parses and validates your SQL right inside your test suite.

But that's just the beginning.

Three Levels of Confidence

QueryLens meets you where you are and scales up as you need it. Each level builds on the last — start simple, go deep when you're ready.

Level 1: Catch Broken SQL with Zero Setup

var query = new SqlQuery("SELECT name FROM customers LIMIT 10");

Assert.True(query.IsValid);

Level 1 is deliberately permissive. Without a dialect, QueryLens accepts common syntax across supported engines and only rejects SQL that is structurally broken. Perfect for a quick safety net across any codebase.

Level 2: Lock Down Your Dialect

QueryLens.Dialect = DialectProfile.SqlServer2017;

var query = new SqlQuery("SELECT STRING_AGG(name, ',') FROM departments");

Assert.True(query.IsValid);  // STRING_AGG exists in SQL Server 2017 — all clear

Set a dialect and QueryLens gets strict: built-in function validation, version-gated function availability, reserved-word warnings, and dialect-specific syntax behavior. That STRING_AGG call would fail validation against SQL Server 2016 — exactly the kind of bug you want to find before deployment.

Level 3: Validate Against Your Real Schema

QueryLens.Dialect = DialectProfile.SqlServer2017;
QueryLens.LoadDbSchemaFrom(connectionString);

var query = new SqlQuery("SELECT id, missing_column FROM customers");

Assert.False(query.IsValid);
Assert.Contains(query.Errors, issue => issue.Code == "QL0011");

Schema loading takes a one-time snapshot of your database and validates against that immutable in-memory copy. QueryLens does not hit the database on every validation call — it's fast, deterministic, and safe for parallel test execution.

Validate Every SQL Statement in Your Entire Project — at Once

This is the power feature. Mark your SQL constants with attributes, then validate your whole assembly in a single test.

public static class OrderQueries
{
    [SqlQuery]
    public static readonly string GetById = "SELECT id, total FROM orders WHERE id = @Id";

    [SqlInsert]
    public static readonly string Create = "INSERT INTO orders (id, total) VALUES (@Id, @Total)";

    [SqlUpdate]
    public static readonly string UpdateTotal = "UPDATE orders SET total = @Total WHERE id = @Id";

    [SqlDelete]
    public static readonly string Remove = "DELETE FROM orders WHERE id = @Id";
}

QueryLens.Dialect = DialectProfile.SqlServer2017;

var result = QueryLens.ValidateAssembly(typeof(OrderQueries).Assembly);

Assert.True(result.AllValid);

ValidateAssembly discovers every field, property, and method decorated with [SqlQuery], [SqlInsert], [SqlUpdate], [SqlDelete], [SqlMerge], or [SqlStoredProc] and validates each one against the active QueryLens level. One test. Every SQL statement. Full coverage.

Drops Right Into Dapper

All statement wrappers implicitly convert to string, so they work seamlessly with Dapper and ADO.NET — no adapters, no extra steps.

await connection.QueryAsync<Customer>(
    new SqlQuery("SELECT * FROM customers WHERE status = @Status"),
    new { Status = "active" });

Supported wrappers: SqlQuery | SqlInsert | SqlUpdate | SqlDelete | SqlMerge | SqlStoredProc

Core API

QueryLens.Dialect = DialectProfile.SqlServer2019;
QueryLens.LoadDbSchemaFrom(connectionString);

var query = new SqlQuery("SELECT * FROM dbo.orders WHERE order_id = @Id");

var isValid = query.IsValid;
var errors = query.Errors;
var warnings = query.Warnings;
var summary = query.ErrorSummary;

Facade members:

Built for Test Suites

QueryLens is designed to be fast and predictable inside your test runner:

• Lazy parsing — nothing happens until you ask for validation
• Cached results — parsed output and validation results are cached
• Zero runtime cost — code that never touches validation pays nothing
• Freeze model — configuration is mutable until first validation, then locks. This keeps cached results deterministic and safe under parallel test execution. Call QueryLens.Reset() to unfreeze.

Documentation

• Interface contracts
• Settings explained
• Testing patterns

License

MIT