"Light" serverless SQL engine with T-SQL language access

Question

I would like to create integration tests for a program that will be connected to a SQL Server in production.

But I would like the unit tests to be shippable and loadable without the need for a running SQL Server...

• I am willing to write a stub to adapt to the alternating SQLServer / "Light SQL for tests"
• I would like to keep the existing T-SQL queries as they are. Not change a single dot in them.

Would you kindly suggest an option ?

Answer 1

Unless you use advanced T-SQL features, SQL CE ought to be enough.