{"library":"pg-lightquery","type":"library","category":null,"description":"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.","language":"javascript","status":"active","version":"0.4.5","tags":["javascript","postgresql","sql","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-lightquery","imports":["import PostgresConnection from 'pg-lightquery';","import { TableBase } from 'pg-lightquery';","import { EnhancedTableBase } from 'pg-lightquery';","import type { ColumnDefinition } from 'pg-lightquery';"]},{"cmd":"yarn add pg-lightquery","imports":[]},{"cmd":"pnpm add pg-lightquery","imports":[]}],"homepage":"https://github.com/dr-aiuta/pgquery#readme","github":"https://github.com/dr-aiuta/pgquery","docs":null,"changelog":null,"pypi":null,"npm":"pg-lightquery","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}