pg-chain

pg-chain is a chainable SQL query builder for PostgreSQL in Node.js, using tagged template literals to construct SQL statements. Version 1.1.3 is the current stable release, with no frequent update cadence documented. It provides methods like SELECT, INSERT_INTO, UPDATE, DELETE_FROM, WITH_RECURSIVE, etc., that return chainable objects. Differentiators include no external dependencies, TypeScript type definitions included, and support for both .toSql() output and direct use with the pg library via .text and .values properties. It is designed for simplicity and composability, allowing reusable conditionals for pagination.