hi, using honey.sql couldn't realize how to use IF function with vanilla helpers (I understand how to call fn's) "IF(table.id is NULL, 0, 1))" I eventually did something like this:

(-> (select [[:sum [[:raw "IF(table.id is null, 0, 1))"]]]])
    (from :table)
    sql/format)

@aviv There's a dedicated #honeysql FYI but that's like any other function call [:if [:= :table.id nil] 0 1]

The web app that John Shaffer built is very helpful for experimenting with expressions: https://www.john-shaffer.com/honeysql/?q=%7B%3Aselect%20%5B%20%5B%20%5B%3Asum%20%5B%3Aif%20%5B%3A%3D%20%3Atable.id%20nil%5D%200%201%5D%5D%20%3Atotal%20%5D%20%5D%0A%20%3Afrom%20%3Atable%7D&opt=%7B%3Apretty%20true%7D

using the REPL mostly and looking on the tests, i'll check this out, thx