I understand what you mean, however, I still think this is a bad DX overall.

There are a lot of good suggestions in these threads about possible tools and approaches, but it just misses the point that these solutions are bad DX and require maintenance.

I think general idea of postgres is good, it's just not ready yet. There needs to be a framework that handles views/functions in postgres as if it's a web app and then applies changes as if it's a terraform. All while taking back-ups in case something goes wrong.

Otherwise it's just more maintenance and it's easier to build API's w/ something else.