I kept running into the same issue when testing repository layers that rely heavily on SQL.

Integration tests with a real database are essential, but they slow feedback cycles and add infrastructure complexity. Mocks don t catch real SQL issues, and SQLite often introduces dialect differences that require adaptation.

So I built an open-source in-memory SQL engine for .NET to validate SQL behavior during unit tests.

It plugs into IDbConnection, allowing repositories (Dapper or raw SQL) to run unchanged while keeping tests fast and deterministic.