pgx

pgx is a simple Object-Document Mapper (ODM) for PostgreSQL, built on top of the popular pg module. Version 0.1.11 is the latest stable release, though the package appears to be in early development with some unimplemented features noted in the README. It aims to make PostgreSQL feel like NoSQL by allowing flexible schemaless operations via JSON columns, while still supporting traditional relational schemas. Key differentiators include automatic creation of tables from schema definitions, support for upsert, batch insert, and join-like reads across multiple schemas. The library is designed for Node.js environments (>=0.10) and uses a callback-based async pattern. Compared to full-featured ORMs like Sequelize or TypeORM, pgx is more lightweight and focuses on quick prototyping with minimal configuration, but lacks advanced features like migrations, transactions, or TypeScript support.