NewPlain creates an in-memory SQLite database without running migrations.
Useful for tests that manage their own schema (e.g. the database package's
own unit tests for Repository, Transaction, and Query).
WithSchema creates an in-memory SQLite database and executes the given
SQL statements to set up a custom schema. Useful for database package
tests that need specific table structures.