Hi! I’d like to know if it’s possible to make multiple where clauses with just format
? Like so:
{:select [...]
:from [:table]
:where [[:= :a "b"]
[:= :b "c"]]}
(the above example of course doesnt work)You're missing :and
at the beginning of the condition.
From the README:
=> '{:where [:and [:= :a #sql/param :baz] [:= :b #sql/inline 42]]
:from (:foo)
:select (#sql/call [:foo :bar] :foo.a #sql/raw "@var := foo.bar")}
I completely missed it in the readme 😕 Apologies for that and thank you!