newbie need help with json_build_object
Hi! Just starting with kysely and encountered problem I cant solve. I want to build raw query with kysely builder...
this part gives me trouble. I would be grateful for your help
Solution:Jump to solution
Here you go https://kyse.link/DqXNv
Note that the properties are nullable in the selected
unit
object because you're using left join. The types are correct. If you are sure there's a unit
for each sku
then use innerJoin
instead....3 Replies
Solution
Here you go https://kyse.link/DqXNv
Note that the properties are nullable in the selected
unit
object because you're using left join. The types are correct. If you are sure there's a unit
for each sku
then use innerJoin
instead.aaa okey, so this is how it's done. Thanks a lot for the quick reply! And for clearing up the other doubt, regarding nullable values. Cool editor btw
You're welcome! The playground is awesome. It's written and maintained by @wirekang https://github.com/wirekang/kysely-playground