kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
Hey 👋 Now that mssql dialect is in the core, it's time to pick and choose which clauses and keywords should get support in Kysely's query API. The [OUTPUT](https://learn.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver16) clause,...
```ts try { const trx = await db.begin().isolationLevel('serializable').execute() await trx.insertInto(...).execute() await trx.savepoint('foobar') try { await trx.updateTable(...).execute() await trx.updateTable(...).execute() } catch (err) { await trx.rollbackToSavepoint('foobar') } await trx.commit() } catch (err)...
Hey! 👋 With MySQL 8.0.19+, it's possible to alias the row being inserted and then reference that alias in the values for `on duplicate key update` [[ref](https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html)]: ```sql insert into...
👋 First just wanted to say this project looks awesome! Pretty close to what I wish Knex was if I started it now, with the affordances of modern TypeScript instead...
Hi, I am really liking this library - thank you to all the supporters. I am adding Kysely to an existing project. The database is MySQL and the tables have...
Anybody already written a MySQL driver to work with Kysely in Deno ? Or is that even needed anymore ? Sry my programming skills are bad and I can't write...
As I was investigating how to implement the [type generation for database views](https://github.com/RobinBlomberg/kysely-codegen/issues/53) I found out that the [MysqlIntrospector](https://github.com/koskimas/kysely/blob/master/src/dialect/mysql/mysql-introspector.ts) already returns views on a `getTables` call. If all introspectors would...
Hey 👋 The new JSON traversal ability released in https://github.com/kysely-org/kysely/releases/tag/0.26.0, might be also viable in a non-type-safe way using `sql.ref`. Probably returning `JSONPathBuilder`.
Hey 👋 The new JSON traversal features released in https://github.com/kysely-org/kysely/releases/tag/0.26.0 require a new recipe, possibly per-dialect like "getting started".
Hey 👋 The new `JSONPathBuilder` released in https://github.com/kysely-org/kysely/releases/tag/0.26.0, could be used in a standalone way - not as part of a JSON reference. Giving consumers the ability to use JSON...