K
Kysely•14mo ago
FINDarkside

How to do join with raw sql snippets?

How can I do this join with kysely? left join videos on videos.id = CAST(highlights_content.item AS INT) AND highlights_content.collection = 'videos' I tried using the provided sql helper but can't really figure out which parts I need to replace with raw SQL for this to be possible.
Solution:
Hey 👋 Try this https://kyse.link/?p=s&i=v8q1aKeqfsLVnYUAseDv...
Jump to solution
2 Replies
Solution
Igal
Igal•14mo ago
FINDarkside
FINDarkside•14mo ago
Thanks a lot!
Want results from more Discord servers?
Add your server
More Posts
More elegant way to handle nested relations?Can someone come up with more elegant solution for handling relations than this? I've modified the eJoin DATE_TRUNCHey, sorry if this is already answered somewhere. I couldn't find anything 😦 I want to translate Why does kysely-codegen generate the schema in node_modules?Like probably many people here, I use https://github.com/RobinBlomberg/kysely-codegen . By default, Any plan to complete the Postgres dialect?Hey there, Is there any plan (or a tracking issue) to complete the Postgres dialect with its specifiConvert date to timestamptzHello. I'm trying to convert the following query from TypeORM querybuilder to Kysely: itemReposiShorthand way to pass the entire update object inside of doUpdateSet when updating multiple values.Greetings! Thanks for developing Kysely, some of the stuff that it does actually blows my mind. I oRaw query for RLS not workingI am trying to migrate a raw query from TypeORM's builtin query builder to Kysely. It's required to Problems typing a generic withPerson helperFirst I want to say that I'm in love with Kysely! It's amazing. I could use some help getting the tyRollback transactionHi, I'm trying to figure out if it's possible to intentionally rollback a transaction, the idea is tsale representative performance for Q3 2015please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestion