{"library":"sql-ts","type":"library","category":null,"description":"sql-ts is a TypeScript-first SQL query builder supporting PostgreSQL, MySQL, Microsoft SQL Server, Oracle, and SQLite dialects. Current stable version is 7.1.0. It generates parameterized queries to prevent SQL injection, supports composite queries, joins, subqueries, and table aliasing. Unlike similar libraries like Knex.js, sql-ts provides strong typing for tables and columns via generics, making it ideal for TypeScript projects that need compile-time safety for SQL queries. Release cadence is irregular. Key differentiator: automatic parameterization and dialect compatibility without SQL generation overhead.","language":"javascript","status":"active","version":"7.1.0","tags":["javascript","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-ts","imports":["import { Sql } from 'sql-ts'","import { TableDefinition } from 'sql-ts'","import type { Queryable } from 'sql-ts'"]},{"cmd":"yarn add sql-ts","imports":[]},{"cmd":"pnpm add sql-ts","imports":[]}],"homepage":"https://github.com/charsleysa/node-sql-ts","github":"git://github.com/charsleysa/node-sql-ts","docs":null,"changelog":null,"pypi":null,"npm":"sql-ts","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}