How do you create a scalar subquery in drizzle?
I want to create the drizzle analog of
select * from table_a where id = (select a_id from table_b where id = <....>)
This works in raw SQL, but I'm not sure how to construct the subquery to get only the a_id field to supply in the where condition.
6 Replies
I can get it to work with
{ id: tableB.aId } but is that the intended way to do it? It doesn't seem to matter what key I use. Adding any extra columns throws a runtime error of PostgresError: subquery must return only one columnYeap, that's the way
The key that you use will just be ignored
The keys are used to map the result to the key you provide, but it has nothing to do with the SQL that's produced
a type thought: would it be worth adding an e.g. scalar subquery type as the output of
select(field), and having that be the type input to filter functions?
that way it would be a type error to pass in multiple column queries into filters at compile time, rather than exploding at runtime
would get rid of the odd "you have to define a key that gets thrown away" DX tooInteresting.
field would be a drizzle column in this case?yes
Sure, that could be a cool feature request