hi. i want to merge-join
a raw subquery. what i do is (merge-join [(raw my-subquery) :foo] my-join-conditions)
. the format output however doesn’t insert the required parenthesis around the subquery in the join clause: INNER JOIN SELECT ... foo
. i need INNER JOIN ( SELECT ... ) foo
. how to do that?
ok got it: (merge-join (sql/raw (str "(" my-subquery ") AS foo")) my-join-conditions)