migrations: Add test for migration query idempotency
Created by: efritz
Add tests to ensure that each migration file can be performed idempotently. This property does not currently hold for the squashed migration at the root of each schema definition.
Test plan
This PR is a test plan!