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.2 Replies
Solution
Hey 👋
Try this
https://kyse.link/?p=s&i=v8q1aKeqfsLVnYUAseDv
Thanks a lot!