The way our team found useful to test database related code is a test container:

1. It is fairly easy to set up
2. You do test actual database calls
3. It is not that slow unless you need a lot of data for your tests

It is not for unit tests, but often it is better to write one good integration test with a decent coverage rather a lot of unit tests testing assumptions not the actual thing.