As we no longer need to support "Modifiers" we can greatly simplify the code to add the flags to the transform preExec.
As this has the potential to break many trigger ART tests, testing this first in main before moving to 24.0.
Properly fixes problem observed in ATR-28872.
cc @sutt