kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
`DatabaseConnection` has a `executeQuery` method. I believe it will be beneficial to add the plural form as well `executeQueries`, which receive an array of queries. This should be exposed from...
Hello, and thanks for the amazing library! 👋 I noticed that when using the `executeTakeFirstOrThrow`, the resulting error will contain the query node by default if the query fails to...
Is there a way to use temp table as the source table in merge statement something like this? `await db.mergeInto('mainTable').using('tempData', 'mainTable.itemCode', 'tempData.itemCode').whenMatched()......` SQL Statement `MERGE INTO MainTable AS Target USING...
Hello, The `CamelCasePlugin` options allow disabling conversion to camel case on all nested objects https://kysely-org.github.io/kysely-apidoc/interfaces/CamelCasePluginOptions.html#maintainNestedObjectKeys, however i don't find this quite useful as for example we might want to keep...
Im using MSSQL and i am having a incorrect syntax error on my recursive CTE [Kysely playground](https://kyse.link/#cN4IgpgJglgLg9gJwM4gFyhgTwA5jSKAW20RgAJgyBxMAOzAQEMZIyBfMgMwTkLIB0QAa0xIwAG0yCA3P1pywADxIJyUWiwSdGAYzBkAIs0YAjRmIpyyZFkhgAVBGDCoy9sHcfPZtNnIXKpGTqmtp6bh4OTvrAVsEQrjT0TCwQADy0AK6EJgwAfD7WtIyELmR2COoA5mQAPmRZ4uKFZNiMThoAkgkN2bkIdb1NPn60IAA0IACOmQyY+EQq5JRIU+LsXDx8giJikjL+tDpwtHZkPADuSGQAvGSMF4ywZBAmcQB0F7AAFgBKYDpMsgoAA3MAACkETkBwLBAFk6JkvGBBOMyODXgBKW55OLWV546xkd57AEwABiW0hIFsUWcgkxhOsn2+DAhgjaHRg3VRAgISF5jXEjNoRKJJIkZPBAG0mUTBFAIPdrpy6NyIKi5dZBMVSsrWu01QA5EooiZavmK-U6b5QcQQHnm0Vi+UgXX6cxkG12iAm0qa51igC6IpdxMytCgJwAgk1weCwCZsTdcYGXYn3qrTpC02HExaxRLxGTKbxqdCgUhQWAEVlkQyC+L1MkAFJwdQ5sNdvm0+tO7thqEAyvV2tI6Lvb32x3jRtiwS9idZ9UBgdE0Nr4mknQwGVz10V2E1xHIye26dKz3Lmf77UgQ9V+EnidT32m-XLv1m2e5gcLyKnlanqvjev7dv+ngTu61rnm+-r9puIY-t2mLIS6qFxBuRYllSQ4wo+x51tEDbOthO6xuI4JYUow4sFRPggGwkzQIwxY7vghBIKs4gTMIogSPM6A0jgeCoDSjBVLx7r4AADO8ABMADs7wAMyMWwQA) Error: `stack: 'Error: Incorrect syntax near \'recursive_menu_tree\'.\n' + ' at RequestTokenHandler.onErrorMessage (webpack-internal:///(rsc)/./node_modules/tedious/lib/token/handler.js:287:21)\n' +...
Add support for json_agg_strict (PostgreSQL only) - this function is just like json_agg, but skips null (see https://www.postgresql.org/docs/current/functions-aggregate.html) A few notes: 1. I've duplicated all json_agg tests and changed them...
Hello, thanks for maintaining Kysely. Would you mind exposing the AllSelection type from select-parser ? It is useful for consumers too.
At [this line](https://github.com/kysely-org/kysely/blob/873ed5a13077773bb7daa1deb7b9d1493a899cf7/src/kysely.ts#L565), the `beginTransaction` call could fail, throwing an error that gets caught on line 570. The issue we are running into is that `rollbackTransaction` then gets called on...
Currently the query builder classes are kept private and interfaces are exported from the codebase. Also, the return value for methods like `db.selectFrom` is an interface and not the runtime...
