Likewise, if there weren't also integration tests that ran against a DB engine more similar to that used in production. But no unit test environment is ever go

Likewise, if there weren't also integration tests that ran against a DB engine more similar to that used in production. But no unit test environment is ever going to emulate everything in production, nor should it.