kysely

kysely copied to clipboard

add modifyEnd to insert, update and delete query builders

3

closes #835

thelinuxlich

Support for CYCLE

4

Hello, I was wondering if it is possible to express the following query with Kysely: ```sql WITH RECURSIVE blok_search AS ( -- Base case SELECT *, 1 AS Depth FROM...

MarkusWendorf

First of all thank you for this great library and support for mssql. You literally saved my life. I'm working with rather huge datasets (3.9M rows joined with other tables)...

fehnomenal

Thanks for the amazing project! It is a real pleasure to work with it! I would like to utilize [read-only transactions](https://www.postgresql.org/docs/current/sql-set-transaction.html). Since I normally use the `SERIALIZABLE` transaction isolation level,...

Bessonov

Add Oracle Database core dialect.

4

Hey 👋 Knex supports OracleDB with a core dialect. As part of becoming THE "drop-in" replacement for Knex, we should look for the easy wins in getting as close as...

igalklebanov

Case of extremely slow type checking

29

I have a query pattern that degrades tsc type checking performance to an outsized degree. It involves a nested query in `selectFrom`, and a simple `where` clause. This is my...

agj

Support `JOIN ... USING ( col1, col2, ... )`

8

Many databases support this shorthand for joins when the column names are the same in both tables. From Postgres docs: > The `USING` clause is a shorthand that allows you...

dwickern

currently, `createTable` has a `temporary` modifier, while `dropTable` does not. while `dropTable` works fine with temporary tables, it would be useful to also add a temporary modifier for the sake...

overflowz

Postgres migrateUp sometimes failing if migration name has a "-" character

2

# Description In versions of kysely < 0.27.2, if migration names have a "-" character (beyond the usual ISO date string), running `migrateToLatest` against a postgres database might fail even...

DavesBorges

Loose typechecking on innerJoin/leftJoin comparisons

5

This was a bit surprising, as it shows a type error correctly on `where` comparisons, see this simple example using branded types https://kyse.link/Rbodk (updated the reproduction with whereRef and where)

thelinuxlich