TypeSQL: write plain SQL strings, get exact TypeScript types (no codegen)

I created this new library that parses Postgres SQL inside TypeScript’s type system. You write a SQL string and the compiler infers the row and parameter types. It needs no codegen and no database connection. const q = sql(SELECT u.id, u.email, p.title FROM users u LEFT JOIN posts p ON p.author_id = u.id WHERE u.id = ${sql.param(7)}); // id: number; email: string; title: string null sql(“SELECT nme FROM users”); // error: column “nme” does not exist * Handles joins, CTEs, subqueries, window functions, INSERT/UPDATE/DELETE … RETURNING * Runs on pg or postgres.js, and can reuse your existing Kysely, Drizzle or Prisma schema * Requires TypeScript 7 https://github.com/ismailkarsli/typesql [https://github.com/ismailkarsli/typesql] Feedback welcome, especially queries that don’t type-check but should.