My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator

The author, Nikita Volkov, shares his 14-year journey away from Object-Relational Mappers (ORMs) and towards a SQL-first approach. He created pGenie, an open-source tool that makes the database the single source of truth. After using ORMs, he realized that abstracting over SQL is usually a mistake and that the query itself should be the integration point. He developed hasql and hasql-th to make raw SQL integration safe and convenient. The author's experience shows that a SQL-first approach can be more effective and safer than using ORMs.