reylo

Reylo lets you write plain SQL in .sql files and import them straight into TypeScript, with the result types worked out for you. Call .run(db, { id: 1 }) and your editor knows the row shape, which columns can be null, and whether you get one row or a list. No ORM, no generated files. It comes from Colin McDonnell, the author of Zod. MIT, free.

Setup is where it gets early. You need TypeScript 7.1, still in beta, Node 24, and a running dev database (Postgres, MySQL or SQLite), because Reylo asks the database to prepare each query and reads the types back. Type checks run as tsc --noEmit --runExternalCode, so CI needs a database too. It works with pg, postgres.js, mysql2, better-sqlite3, Bun.sql or Drizzle. Nothing is paid. Solo and small teams: free, try it on a side project. Larger teams: wait for TypeScript 7.1 stable.

The catch: the public repo is about a week old, on version 0.6.0, which already changed what some queries return. Expect breaking changes. The README also lists DuckDB, but the DuckDB engine on npm is still a placeholder. For something proven today, PgTyped and SafeQL do similar jobs on stable TypeScript.