I will definitely write an extension to support SQLite (as already planned) and bundle SQLite for testing, thank you for the reassurance regarding this question, tobyink.

The tests are run against all supported databases during development, but I guess a user would target one specific DBMS. So, I think looking for environment variables specifying one database connection is enough.