Supabase cli has a decent diffing option to generate migrations (not sure what they use, but it’s open source), it works quite decent for schema changes.

Not as advanced as you describe though, it won’t handle your data migrations.