{:Sql "select *
from public.currency
where stat = 'crypton.transfer.roll_entries'
  and ingest_ts > date '2022-05-29'
  and s_data.\"unix_day\" IN :days
  and version like '66.%'
limit 10"
        :Parameters
        [{:name "days"
          :value (str "( " (str/join ", " [19140 19139]) " )")}]}

What database libraries are you using? I'd use HoneySQL to build the whole [SQL & params] vector -- it understands [:where [:in :days data]] (although you can't use a named parameter here -- you have to let HoneySQL generate the ? placeholders).

If you use postgres you can use a single ? and pass an array (not a vector or a list - java array) and that works

honeysql's approach orks the most generically though

alright thanks