While Alpha 2 was mostly a documentation expansion over Alpha 1, Alpha 3 has a lot of new functionality as well as improved documentation:
A lot of work has gone into expanding DDL support in this release, as well as TOP, FETCH, OFFSET, LATERAL, SELECT .. INTO, a way of performing a series of JOIN’s in a specific order, and a number of other things.
The README has both a data DSL version and a helper version of most examples now. All the helper functions have docstrings. This alpha also provides parity with nilenso/honeysql-postgres 0.3.104 (but it just had a new release with some new features which will be incorporated into the next HoneySQL release).
For Leiningen: [com.github.seancorfield/honeysql "2.0.0-alpha3"]
For deps.edn: com.github.seancorfield/honeysql {:mvn/version "2.0.0-alpha3"}
Note that I’ve switched to a reverse domain name group ID with this release, per Cloars’ Verified Group Names policy (but I am also double-publishing under the old seancorfield group for now).
(require '[honey.sql :as sql] '[honey.sql.helpers :as h])
;; you can :refer whatever helpers you want from honey.sql.helpers
;; but it has six helpers now that shadow clojure.core functions:
;; for, group-by, into, partition-by, set, and update
If you’re new to HoneySQL, read the Getting Started guide otherwise you could start with the SQL Clause Reference…
Note: This can be used alongside HoneySQL 1.0 because it uses a different group ID and different namespaces, so you can migrate to 2.0 one SQL statement at a time!
Please test and provide feedback!