Kysely
Kysely is a SQL query generator based on TypeScript, offering type-safe and automatic completion support. It can run in Node.js, Deno, Bun, Cloudflare Workers, and browser environments. It provides type checking at compile time by matching query results with the correct types over selected columns and aliases.
Kysely
100kysely-org · ORM & Database Tooling
- You write type-safe and SQL queries with automatic completion support in TypeScript projects.
- You automatically remove column names and types via subquestions, merge operations, and 'with' expressions.
- You use custom template tags and dynamic modules provided for situations that cannot be typed at compile time.
- • NeutralHacker News
Kysely: TypeScript SQL Query Builder
“The main difference to me is that with Prisma I don't need to do any SQL to get a project up and running. I can define the tables and relations from my code or from Prisma Studio, and in one swoop I get the db structure done and the types defined. I know my way around a…”
- • NeutralHacker News
Kysely: TypeScript SQL Query Builder
“You can use these template literal types + infer to build an entire SQL parser. I did a POC that infers SQL query types by parsing the SQL query on a type level: Building this parser is pretty cumbersome and supporting multiple SQL dialects would be lots of pain. While I'm not a…”