New day, new question. I would love to be able to create a temporary table, but there doesn’t seem to be a hh/create-tmp-table (or underlying support for {:create-tmp-table ...} ?

I ended up with (at least for now)

(honey.sql/register-clause! :create-temp-table (fn [_ args]
                                                 [(str "CREATE TEMP TABLE " (name args) " AS")])
                            :select)

Next question: I want to duplicate some rows in a table while changing one column. I don’t want to enumerate all the columns, so I’ve come up with this:

CREATE TEMP TABLE tmp AS (select * from foo where lol = 42);
UPDATE tmp SET lol = 43;
INSERT INTO foo (SELECT * from tmp);
DROP TABLE tmp;

(let [tmp-table (gensym)]
    [(-> {:create-temp-table (keyword tmp-table)}
         (hh/select :*)
         (hh/from (keyword "foo")
         (hh/where [:= :lol 42))
     (-> (hh/update (keyword tmp-table))
         (hh/set {:lol 43}))
     (-> (hh/insert-into [(keyword "foo")
                          (-> (hh/select :*)
                              (hh/from (keyword tmp-table)))]))
     (hh/drop-table tmp-table)]))

Oh, my colleague was smarter than me: (hh/create-table-as :temp (keyword tmp-table)) gives me a temp table 🙂

Yeah, I should probably call that out in the docs that all the :create* operations accept one or more keywords and just make SQL out of them 🙂

user=> (sql/format (-> (create-table-as :fee :fie :foe :fum) (select :*) (from :bar)))
["CREATE FEE FIE FOE TABLE fum AS SELECT * FROM bar"]
user=>

https://github.com/seancorfield/honeysql/issues/435

And, just in case you weren't aware, I'm really appreciative of the work you do with next.jdbc and honey. They're such a pleasure to work with!