The solution is that nothing gets to production unless it gets migrated in via the CI pipeline. Admittedly it's still a problem during development.

But a tool like Flyway versions your DB. You know if you are out of date as the migration table is behind.

It's not as good as compiled code but it works when you need it.