That's fair enough. I meant in situations like parent comment where you're using an ORM such as hibernate that supports multiple databases, you can test as muc

That's fair enough. I meant in situations like parent comment where you're using an ORM such as hibernate that supports multiple databases, you can test as much of the non-DB specific stuff with SQLite in-memory and then do a separate batch of tests with DB specific behaviour.