kysely

Kysely is a TypeScript SQL query builder designed to provide type safety and autocompletion for database queries. It ensures that developers only refer to tables and columns visible to the specific part of the query being written, with result types that accurately reflect selected columns, aliases, and types. Key capabilities include: - Type inference for column names, aliases, and types from selected subqueries, joined subqueries, and `with` statements. - Support for multiple database dialects including PostgreSQL, MySQL, MSSQL, SQLite, and PGlite. - Compatibility with various JavaScript environments such as Node.js, Deno, Bun, Cloudflare Workers, and web browsers. - Escape hatches for scenarios that cannot be typed at compile time, such as the `sql` template tag and `DynamicModule`. Kysely is inspired by Knex.js but focuses on leveraging modern TypeScript features to provide a more robust type-safe experience.