{"library":"simple-typed-sql","type":"library","category":null,"description":"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.","language":"javascript","status":"active","version":"0.8.6","tags":["javascript","typescript","sql","node"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install simple-typed-sql","imports":["import { Mapper } from 'simple-typed-sql';","import { defineMapping } from 'simple-typed-sql';","import { defineNumber } from 'simple-typed-sql';"]},{"cmd":"yarn add simple-typed-sql","imports":[]},{"cmd":"pnpm add simple-typed-sql","imports":[]}],"homepage":"https://github.com/smphhh/simple-typed-sql#readme","github":"https://github.com/smphhh/simple-typed-sql","docs":null,"changelog":null,"pypi":null,"npm":"simple-typed-sql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}