[rjbwork]

Since this thread is likely to attract good answers to this...

Are there any Terraform-like declarative tools for your schemas that will do a diff and generate a change script?

I've seen liquibase and it's just a series of migrations which I think is pretty gross.

I really like MS's SSDT tools, but the DACPAC workflow is pretty heavy to operationalize, though doable.

[nerdponx]

Prisma maybe? https://www.prisma.io/

It's mostly part of a JS/TS ORM, but it uses a declarative schema language, and there are libraries in other languages to parse and process it. E.g. https://prisma-client-py.readthedocs.io/en/stable/