If you are using Views, there is also the possibility to shift the unit tests to the database layer to ensure some of its logic (at least with some databases, e.g. MS SQL using tSQLt or Oracle using utPLSQL).
Database logic can then be treated as separate module, which can be beneficial.