3 Replies
If you mean structuring the subquery as an object inside the main select yes it's possible
Mind explaining a bit more what you want?
I think it's the same issue we had with CASE https://discord.com/channels/890118421587578920/1184681470531469423
if I write
eb.fn.coalesce(subquery.limit(1), 'foo') Kysely won't recognize the subquery is returning a single valueOh, might not be possible at the moment. We have special handling for single-select subqueries in a bunch of places, but not there.