Eg:

(-> (sql.h/insert-into :my-foo [:id
                                :jsonb-1
                                :jsonb-2
                                :frob])
    (sql.h/values [[1
                    [:lift {}]
                    [:lift []]
                    [:lift "text"]]])
    sql/format)
=> ["INSERT INTO my_foo (id, jsonb_1, jsonb_2, frob) VALUES (?, ?, ?, ?)" 1 {} [] "text"]

Already aware of this: https://clojurians.slack.com/archives/C66EM8D5H/p1643310886155809 I guess it would affect the prepared statement slightly :thinking_face:

Shouldn't be any risk.

Well, unless you start wrapping wrong things, i.e. data structures that HoneySQL is supposed to parse. :)

Thanks! Would you say this is rarely the case when passing values inside values ? In my case the values [1 {} [] "text"] (or whatever values are passed in) would get wrapped with :lift , no questions asked.

Maybe that’s a hard one to answer.

Okay, all I had to do was to ask the REPL:

(sql/format (sql.h/values [{:id 1 :value [:inline "moi"]}]))
=> ["(id, value) VALUES (?, 'moi')" 1]
(sql/format (sql.h/values [{:id 1 :value [:lift [:inline "moi"]]}]))
=> ["(id, value) VALUES (?, ?)" 1 [:inline "moi"]]

Doesn’t really answer the question about occurrence rate, but clears up my understanding of what is meant by HoneySQL parseables. Occurrence rate was perhaps the wrong question and something for me to figure out in my context. Thanks for the help!