pg-schemata

A lightweight Postgres-first ORM layer built on pg-promise (v1.3.3) for Node.js 18+. Defines table schemas in code, auto-generates ColumnSets for efficient CRUD, rich WHERE modifiers (like $like, $ilike, $from, $to, $in), cursor-based pagination, multi-schema support, DTO validation via Zod, extensible class inheritance, and migration management. Alternatives like Sequelize or TypeORM offer heavier abstractions; pg-schemata stays close to SQL while reducing boilerplate.