Quackatos - Well-Typed Postgres Query Builder
JSON →Quackatos is an extremely well-typed query builder for Postgres, built on top of Zapatos (v6.0.1+). Current stable version is 1.8.0, with active development. It prioritizes type safety: query results are fully typed based on the database schema generated by Zapatos, and any code without type errors should generate a valid SQL query. Unlike Knex (weakly typed, multi-dialect) or Prisma (strongly typed, ORM-heavy), Quackatos stays close to SQL and is Postgres-only. It provides intuitive methods like select, where, join, limit, etc., and returns typed tuples or objects. Release cadence is sparse but maintained.
Resources
packagequackatos ↗