fwiw, I personally am interested in this approach too[0]. I keep running into roadblocks around the ordering of events and some of the hairy issues around "destructive" actions (eg: renaming columns). i think we can get there, especially once we make progress with this LSP.
There are other notable mentions in this space:
Reshape: https://fabianlindfors.se/blog/schema-migrations-in-postgres...
Atlas: https://atlasgo.io/
A "custom" example on GitLab: https://gitlab.com/delibrium/delibrium-postgrest/-/tree/mast...
[0] https://github.com/kiwicopple/declarative-schemas