How to do join with raw sql snippets?

How can I do this join with kysely? left join videos on = 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
FINDarkside16mo ago
Thanks a lot!