ts-sql-query

ts-sql-query is a type-safe SQL query builder for TypeScript, inspired by Java's QueryDSL and JOOQ, supporting MariaDB, MySQL, Oracle, PostgreSQL, SQLite, and SQL Server. Current stable version is 1.67.0, with regular releases following minor updates. It emphasizes compile-time type checking for SQL queries, dynamic query construction, and avoids ORM patterns, making it suitable for projects requiring full SQL control without string concatenation. Unlike Knex or TypeORM, it provides first-class TypeScript support with inferred result types and no runtime schema generation.