Simple Typed SQL
JSON →TypeScript SQL query builder with type-safe column references and auto-completion. Current stable version is 0.8.6, released as a single major version since 2016. Unlike Knex.js or TypeORM, it provides partial type safety by mapping TypeScript interfaces to database tables, eliminating string-based column names. Supports SELECT, INSERT, UPDATE, JOINs, WHERE clauses (including complex conditions), transactions, and aggregation. Under the hood: Knex.js for query execution. Release cadence is low, with ongoing work on SELECT expressions. Key limitation: only partial type safety (not full compile-time checks). Ships TypeScript types.
Resources
packagesimple-typed-sql ↗