There are ticketing paradigms that don't require alerting in the middle of the night. All you need to repo and fix a bad query is the query itself and/or an explain of the query itself, and you can work on it during business hours.

I'm sorry you've had bad experiences with alert-all-the-things ticketing paradigms.

addendum: in fact, you can automate all of this so it just shows up in a team's "known issues" query that they may manage in standup or sprint planning.