migrations: Add test to ensure extension modifications are marked as privileged
Created by: efritz
Add a verbose error when new migrations altering Postgres extensions are not marked as privileged.
Test plan
This adds tests that should catch any violations in CI.