HI all! I wanted to share a useful tool that I built during the pandemic. (if this is the wrong mailing list, please let me know where I should be sharing this, thanks)
I do a lot of functional programming and need dynamic SQL. My personal belief is that ORMs are the wrong interface to creating migrations, and I prefer a pg native, functional approach. This library was actually one of the base extensions of a larger set, and I used this to create higher level structures for creating migrations. So while this is “low-level” you can definitely create stored procedures that do make it higher-level if you wish. I hope some of you find this useful with your projects! postgres-ast-deparser A pure plpgsql AST toolkit and deparser for PostgreSQL, which can be used to create ASTs and deparse them back into strings in native Postgres. https://github.com/pyramation/postgres-ast-deparser