v2-database-queries

name	v2-database-queries
description	Describes how the API writes PostgreSQL access in v2 using PgTyped SQL files, generated query modules, and curried wrappers in index.ts. Use when adding or changing queries under app/src/data/queries, wiring PoolClient, transactions, or composing multiple queries; not for legacy v1 query code.

v2 database queries (PgTyped)

Where it lives

• SQL and generated code: app/src/data/queries/<entity>/
• Imports from route code should use import … from "@data/…" (see app/tsconfig.json). Legacy votes module lives in a misnamed file legacy-queries/votes/index.ts.ts; import it as @data/legacy-queries/votes/index.ts until that file is renamed.
• One folder per entity (e.g. bets, predictions, users).
• Reference implementation: read existing folders in that tree; follow the same shape as bets/ and predictions/.

Tooling

• PgTyped turns annotated SQL into TypeScript: parameter types, result row types, and PreparedQuery instances with a .run(params, client) method.
• Config: app/pgtyped.config.json — srcDir is ./src/data/queries; each *.sql file emits a sibling {{name}}.queries.ts (e.g. bets.sql → bets.queries.ts).
• Watch / regen: from the package, runs with that config. Repo root runs API dev together with via , so generated files update when SQL changes.