tuple() and refTuple() questions
Hello, i would like to generate this query
DELETE FROM table WHERE (col1,col2,col3) IN (...insert values);
i found out from my code editor intellisense that tuple() and refTuple() exist, but to my surprise, i can only insert 2 values in a single tuple.
is there a way for me to achieve that in kysely? or do i stick to raw sql for that?
PS: i thought nesting would work, like tuple(tuple(a, b), c), but that's obviously not it3 Replies
Solution
There's no such limitation
ah i see now, there are typings for 5 such columns at most
i must have done something wrong
leading me to that conclusion
thanks 👍