I've come to the same conclusions. Our tooling still requires an integer as the first part of the script name - but that's only used to determine overall execu

I've come to the same conclusions. Our tooling still requires an integer as the first part of the script name - but that's only used to determine overall execution order. The numbers can overlap and there can be gaps which helps with the branching problem. I also agree that idempotent scripts are a key best practice. We also persist a hash of the script in the database so that our tools can detect when a script has been modified after it was applied. This has helped catch and prevent a whole class of bugs.