Hi, I found myself sometimes doing things like
(sql/call :and
(sql/call := :ci.something true)
(sql/call :or
(sql/call ....)
Because I am using it outside the where, but to construct a boolean column in the select statement. Is there anyway I could write all this with the format used in where in the select?
this one:
[:and [:= :ci.something true]
[:or
[...]]]
I don't believe so. Part of that is due to select
expecting either a column name or a vector pair containing a column selector and an alias -- so there would be a conflict between [:and ...]
and [:col :alias]
that you'd have to figure out somehow.