Hi! Is there a way to force (values [{:id 1, :valid true}]) to generate "... values(?,?)" instead of "... values(?,TRUE)" ? I have been reading the docs and code but could not figure it out 🙏

That's what :lift is for:

dev=> (sql/format (h/values [{:id 1 :value true}]))
["(id, value) VALUES (?, TRUE)" 1]
dev=> (sql/format (h/values [{:id 1 :value [:lift true]}]))
["(id, value) VALUES (?, ?)" 1 true]
dev=> 

Thanks a lot! I believed I saw something like that in the docs when I first read them but when I was searching them I obviously failed to find the right search terms / look at the right place 😔

Hey hello, does anybody knows if is possible to reproduce this in honeysql?

ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES addresses (address);

I’m having a little trouble getting sql functions working with honeysql. Taking this example directly out of the readme:

(-> {:select [[[:max :id]]], :from [:foo]} sql/format)

Execution error (AssertionError) at honeysql.format/seq->sql (format.cljc:385).
Assert failed: Alias should have two parts[[:max :id]]