I figured the issue was that {:select [:< 1 2]} was just bad syntax and the parameterization was fine
you could extend honeysql pretty easily to make a smarter version of call that wouldn't lift numbers
the way the honeysql compiler works, you just create a new record to hold your values and then a wrapper for that record, and then register into ToSql so the compiler knows what to do
apparently there is a recent feature called inline
that does this
user=> (format (select (call :< (inline 1) (inline 2))))
["SELECT 1 < 2"]
also amusing to me that inline
was added in response to a @seancorfield PR
@bja Ah, that explains why this issue felt so familiar!
Ah that seems better than the raw option. Feels a bit more composable. Thanks @bja