pqb
JSON →pqb is a TypeScript-first query builder for PostgreSQL, part of the Orchid ORM ecosystem. Current stable version is 0.66.6. It focuses on providing full type safety for queries and results, with support for dynamic queries, joins, subqueries, and transactions. Compared to knex or kysely, pqb integrates tightly with Orchid ORM but can also be used standalone. The package ships its own TypeScript types and is actively maintained with weekly releases.
Resources
packagepqb ↗