kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
Hey 👋 Join our discord server by following this [link](https://discord.gg/fqPmedHnyM). Here are some indexed questions from our #help channel, courtesy of [AnswerOverflow](https://www.answeroverflow.com/c/890118421587578920).
Hey 👋 Currently we don't support adding indexes in `CreateTableBuilder`. This is supported in MySQL, and other non-builtin dialects. Also, we should align with #507 & #508 if the proposed...
Originally discussed in https://github.com/kysely-org/kysely/issues/397#issuecomment-1553177254. This would allow support for the [frame spec](https://www.sqlite.org/syntax/frame-spec.html) of SQLite. As suggested by @igalklebanov in https://github.com/kysely-org/kysely/issues/397#issuecomment-1553239805 a new syntax `.modifyEnd` and `.modifyFront` could be added to...
With a query like ``` .selectAll('orders') .select([ sql`ENCODE(ordinal_order_id::bytea, 'hex')`.as('ordinal_order_id') ]) ``` I'd expect ordinal_order_id in result to be `string` type, but it ends up being `Buffer & string`. In DB,...
When using PostgresSQL's inheritance, one may want to execute a `SELECT` using the `ONLY` keyword. For example: ```sql SELECT name, elevation FROM ONLY cities WHERE elevation > 500; ``` Or...
When using delete with leftJoin, you need to use a syntax similar to `DELETE [TABLE] FROM [TABLE]`, but I not found any implementation methods other than raw in the document...
The last 2 snippets @koskimas posted at https://github.com/koskimas/kysely/issues/76#issuecomment-1093829973 are a really good QoL and type-safety improvement for the common use case mentioned in that issue. Keep in mind: [postgres](https://www.postgresql.org/docs/current/sql-values.html#:~:text=VALUES%20computes%20a%20row%20value,the%20same%20number%20of%20elements.) supports...
As we're gearing up for v1, a refactor following #260 introduced renames to some utility methods that do not map to sql keywords/clauses, and added a `$` prefix to their...
Hello. I would like to distinguish between partitioned and non-partitioned tables in the kysely-codegen project. To do this, it is necessary to add an isPartitionTable property to TableMetadata ( https://github.com/kysely-org/kysely/blob/master/src/dialect/database-introspector.ts...
Hey :wave: Right now, `InferResult` wrongfully outputs a singular type, despite queries actually having a plural result type when executed. This PR makes it plural instead. This will enable simpler...