Zapatos

Zapatos is a 'zero-abstraction' database library specifically designed for TypeScript and Postgres. It provides strong type safety by generating a detailed TypeScript schema directly from your existing Postgres database, reducing the boilerplate and common pitfalls associated with traditional ORMs. The library facilitates writing arbitrary SQL queries using tagged templates, offers shortcut functions for everyday CRUD operations, and supports complex data structures like nested JSON via LATERAL JOINs, all while maintaining full type inference. Unlike many ORMs, Zapatos does not manage connection pools, explicitly relying on the underlying `pg` module, and does not aim to be database-agnostic or provide a 'code-first' approach. Currently at version 6.6.1, Zapatos maintains an active development status, with a focus on integrating seamlessly with Postgres's native capabilities and TypeScript's type system.