generating raw sql?
I think I saw somewhere an option that you can build a query using kysely and convert it to raw sql, but I can't find that anywhere. Does such an option exist or did I get something mixed up?
Unknown User•17d ago
Message Not Public
Sign In & Join Server To View
Solution
Igal•17d ago
Hey 👋
Use the
.compile()
method instead of executing.
For more info, check out the link @53ny posted.1.4KMembers
View on DiscordWant results from more Discord servers?
More PostsConditionally updating fieldsHow would i go about doing something like
`UPDATE table SET field = IF(condition, trueValue, falseVaHow to cast to date. eg : `DATE(created_at)`How to write this query in kysely
```sql
SELECT DATE(created_at) AS date, SUM(points) AS score
FROtransaction takes too longI have a problem with transactions. What might be the reason that db.transaction() adds more than 10Syntax error when empty array is passed to a WHERE filter (request for more readable errors)In a query like `someQuery.where("x", "in", xs)`, if `xs` is empty, then the error will be somethingDerived tables for PostgresHi, I am trying to do a bulk update like this:
```
UPDATE your_table
SET someColumn = new_values.newComplex Query Builder from dynamic input - Typescript issueHi, it's me - again 🙂
I'm currently trying to migrate our current query builder.
It seems that eHow to add table/column comments when creating tables?Hey, we're approaching close to 100 tables in our project. New people will be joining our founding tNeed help improving a custom helperMy dopamine with Kysely is quite high right now, so I am experimenting all sorts of things to createjsonArrayFrom with `as` not being typedI have the following query
```ts
await db
.selectFrom('user')
.selectAll()
.select((eb) How to use multiple schema definitions ( e.g. <catalog>.<schema>.<table> )Hey guys,
I'm currently working on a new version for our graphql wrapper.
Currently we're using kne