If I have an application that uses a database as its data store (and ultimate source of truth) that brings some obvious issues when developing tests: In the applications, objects should ONLY be ...

You are creating a database from scratch for an application This application will have multiple siloed environments (PROD, TST, INT, DEV) Data from PROD will nightly be moved to the other environments ...