SQLLogicTest is a huge test suite used by engines like SQLite and DuckDB to check that SQL queries behave correctly. It runs over 7 million queries and compares results across systems like PostgreSQL, MySQL, and Oracle.

We just started adding SQLLogicTest support to Mochi, beginning with a small file that tests basic UPDATE statements. It’s already helping us catch edge cases and build confidence in our SQL engine.

If you’ve worked with SQLLogicTest or similar test suites, we’d love to hear your experience: what helped, what didn’t, and any tips for making it scale!