HoneySQL 2.0 Alpha 3

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!

10 Likes

Added the test suite of honeysql 2.0.0-rc2 to babashka CI and all tests are passing.

4 Likes