Begin starts a savepoint-based transaction scope that auto-rolls back when
the test completes. This provides per-test isolation without recreating the
database schema.
Uses SQLite SAVEPOINTs for isolation since SQLite only supports a single
active transaction.