My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator
Summary
Nikita Volkov recounts his transition from ORM-based approaches to a SQL-first paradigm with pGenie, a Postgres code generator. He argues that the database should be the single source of truth, with migrations as contracts and queries as the primary integration point, yielding automatically derived, type-safe SDKs. In the AI era, pGenie provides verification that AI-generated SQL remains valid against the actual schema, enabling high-velocity, safe data access.