I really like flyway. It’s lightweight and the best thing I can say about it is that I rarely have to bother with it. It just works.

I too find it useful to keep the migrations small and succinct. For Oracle do migrations where the DDL cannot be rolledback I choose to separate these from straight data manipulation.

A downside to the project that I see is that although it’s quite mature the author is very very slow to engage with open source modifications.

I’d still make it my first choice because of its simplicity.