PogPEGA
PogPEGA
KKysely
Created by PogPEGA on 10/7/2024 in #help
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 it
8 replies
KKysely
Created by PogPEGA on 10/2/2024 in #help
Execute RAW Sql Queries
hello, is it possible to execute any raw query supported by my underlying sql driver with kysely? i could not find any such function in the docs or the guide book for example, describe table_name errors because kysely itself cannot compile it. i am using mysql2 as my driver.
4 replies
KKysely
Created by PogPEGA on 4/29/2024 in #help
Conditionally updating fields
How would i go about doing something like UPDATE table SET field = IF(condition, trueValue, falseValue) WHERE someCondition;, i can't exactly seem to find that in the docs Driver used: MySQL
4 replies