Обсуждение: Postgres AST Deparser for Postgres

Поиск
Список
Период
Сортировка

Postgres AST Deparser for Postgres

От
Dan Lynch
Дата:
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.