Clojurians Log v2

can someone help me to translate the following sql snippet into plain honeysql query:

with grants as
  (select * from grants_table
    where (user_id = 'foo'))
select * from grants

:select :* :from  :grants-table
:where [:= :user-id "foo"]

I think I figured it out, it’ll be something like:

:with [[:grants {:select [:*] :from [:grants-table] :where [:= :user-id "foo]}]]
:select :* :from :grants

Ah. Now I’m struggling with the following construct:

select (case
          when ( count(*) < 0 ) then 'yes'
          else 'no'
        end)
from my_table

ah, seems it involves using sql/call