kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
Hi 👋, I've been using kysely for production at work. We're using [kysely-codegen](https://github.com/RobinBlomberg/kysely-codegen) to generate type definitions. One thing that I've noticed is that generated/computed columns are excluded from introspection...
Hey 👋 The only way to modify a column's nullability in MS SQL Server is to also set a data type. https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver16#syntax-for-disk-based-tables Currently, `setDataType(dataType)`, `setNull()`, and `setNotNull()` cannot be chained...
Adds an AlterTypeBuilder (closes #981). This implementation includes the SET OWNER, RENAME TO, SET SCHEMA, ADD VALUE and RENAME VALUE query forms.
Right now [coalesce only supports a maximum of 5 elements](https://github.com/kysely-org/kysely/blob/671699fe62c41dccd0c7c4bb08e476f7e3074949/src/query-builder/function-module.ts#L314). As I would need 6, do you see any reason to note allow for more? I'm happy to open a...
Hey 👋 We need a way to use `eb.ref` (maybe a separate function) but let downstream get the `InsertType` or `UpdateType` instead of the `SelectType`. Example where it's needed: https://github.com/kysely-org/kysely/issues/664#issuecomment-2025848917...
Hi, As you know better-sqlite3 is the default sqlite drive in Kysely and is synchronous. The issue with this is that it blocks the full event look during each query....
# Parameter Reuse Optimization for SQL Template Literals ## Current Behavior When using SQL template literals with Kysely, identical parameters are assigned new parameter indices each time they appear in...
currently it is defined like this: ```typescript $if( condition: boolean, func: (qb: this) => SelectQueryBuilder ): ...; ``` however that means that if condition is a type-guard we must re-check...
Hey 👋 Kysely is part of an ecosystem. The ecosystem has libraries that manage their own database tables with their own APIs or CLIs. e.g., auth libraries like `better-auth`. e.g.,...
Hey 👋 Proposal: Similar to the proposal @ #1404, we could also use `Readonly` to represent the equivalent of `ColumnType` for column types, but in a TypeScript-native way that's much...