pg-lightquery

pg-lightquery is a modern, type-safe PostgreSQL query builder for Node.js with TypeScript support (v0.4.5). It offers deferred execution, fluent CTE-based multi-table operations, smart operators (LIKE, IN, date ranges, JSON queries), complex joins, transaction builder, optional audit fields with lastChangedBy tracking, and minimal dependencies (only 4 core packages). Unlike heavier ORMs like Sequelize, it focuses on composable, security-first design with separate column validation and data projection. Suitable for Node.js applications requiring type-safe SQL generation with full control.