A somewhat similar previous discussion: https://clojurians.slack.com/archives/C66EM8D5H/p1625797454111000 That doesn't exactly answer your question, but if you need that to insert multiple items then there's insert-multi!.

Unfortunately it’s not the use-case…

I need to update values in batch, so I’m searching something with this template:

(jdbc/execute-batch! ds
                        "UPDATE agent_event SET seen = TRUE WHERE (agent_id = ?) AND (event_id IN (?))"
                     [["id1" "eid1"] ["id2" "eid2"] ["id3 "eid3"]])

trying to figure out what will work on this case

Not sure whether it's the best approach but you can create a regular sqlmap where all the positional parameters are represented by [:raw "?"].

(honey.sql/format {:update :agent-event
                   :set    {:seen [:inline true]}
                   :where  [:and
                            [:= :agent-id [:raw "?"]]
                            [:in :event-id [[:raw "?"]]]]})
=> ["UPDATE agent_event SET seen = TRUE WHERE (agent_id = ?) AND (event_id IN (?))"]

Thanks 🙏 I had [:raw "?"] missing 🙂

Perhaps slightly less ugly:

user=> (honey.sql/format {:update :agent-event
  #_=>                    :set    {:seen [:inline true]}
  #_=>                    :where  [:and
  #_=>                             [:= :agent-id :'?]
  #_=>                             [:in :event-id [:nest :'?]]]})
["UPDATE agent_event SET seen = TRUE WHERE (agent_id = ?) AND (event_id IN (?))"]

:' allows for "literal" symbols