honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
dharrigan 2021-03-13T07:46:46.128Z

thank you! looks great!

seancorfield 2021-03-13T23:59:41.128800Z

com.github.seancorfield/honeysql {:mvn/version "2.0.0-alpha3"} is available on Clojars for testing — lots of new stuff in this Alpha release: * Change coordinates to com.github.seancorfield/honeysql (although new versions will continue to be deployed to seancorfield/honeysql for a while -- see the [Clojars Verified Group Names policy](https://github.com/clojars/clojars-web/wiki/Verified-Group-Names)). * Support much richer range of syntax on CREATE/`DROP` statements in general, including columns, TABLESPACE, CASCADE, WITH [NO] DATA, etc. * Fix #306 by supporting CREATE TABLE .. AS ... * Fix #305 by supporting more complex join clauses. * Fix #303 by supporting MySQL’s ON DUPLICATE KEY UPDATE. * Fix #301 by adding support for CREATE/`DROP`/`REFRESH` on MATERIALIZED VIEW. * Add tests to confirm #299 does not affect v2. * Fix #297 by adding both SELECT .. INTO .. and SELECT .. BULK COLLECT INTO ... * Fix #295 by adding docstrings to all helper functions (and adding an assert to ensure it stays that way as more are added in future). * Confirm the whole of the [nilenso/honeysql-postgres](https://github.com/nilenso/honeysql-postgres) is implemented out-of-the-box (#293, but see #310 for recent additions not yet incorporated). * Fix #292 by adding support for SELECT TOP and OFFSET/`FETCH`. * Fix #284 by adding support for LATERAL (as special syntax, with a helper). * Reconcile where behavior with recent 1.0 changes (porting #283 to v2). * Fix #280 by adding :escape as special syntax for regular expression patterns. * Fix #277 by adding :join-by/`join-by` so that you can have multiple JOIN’s in a specific order.

🎉 1