Unless you use SQLite in production as well, this can give you a false sense of security, as there can be subtle behavior differences between DBMSs. Ideally you should always test with the same DBMS and same version as used in production.

This is the same risk with mocking/stubbing, but for integration tests it's important that you're testing with the actual system used in production.