{"library":"quackatos","type":"library","category":null,"description":"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.","language":"javascript","status":"active","version":"1.8.0","tags":["javascript","🦆","query","builder","zapatos","postgres","sql","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install quackatos","imports":["import q from 'quackatos'","import { QueryBuilder } from 'quackatos'","import type { RunResult } from 'quackatos'"]},{"cmd":"yarn add quackatos","imports":[]},{"cmd":"pnpm add quackatos","imports":[]}],"homepage":"https://github.com/seamapi/quackatos#readme","github":"ssh://git@github.com/seamapi/quackatos","docs":null,"changelog":null,"pypi":null,"npm":"quackatos","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}