Are there examples out there for writing CTE in honeysql? I’m basically trying to write insert queries with https://dba.stackexchange.com/questions/46410/how-do-i-insert-a-row-which-contains-a-foreign-key so it involves quite a few types of clauses in one go where the interactions are not described in the docs

@achan961117 You mean like this? https://cljdoc.org/d/com.github.seancorfield/honeysql/2.0.0-rc2/doc/getting-started/sql-clause-reference#with-with-recursive

And if you're still using 1.x, the first test here has an example: https://github.com/seancorfield/honeysql/blob/v1/test/honeysql/core_test.cljc#L16