Revert=rollback
I came across another post that confused me about best practices for handling stored logic in Liquibase. Specifically, in this discussion (How do I manage rolling back changes made to "rerunnable" (runOnChange=true) changelogs that contain stored logic?), you seem to suggest avoiding runOnChange:true for stored logic.
However, my understanding was that runOnChange:true allows us to maintain a single SQL file for stored logic without needing to create multiple files for each change.
Could you clarify your recommendation? When is it appropriate to use runOnChange:true, and what is the best practice for managing changes and rollbacks with stored logic?