- Upgrade the
honeysql
dependency from0.9.5
to1.0.461
- Support
FILTER
+WITHIN GROUP
for aggregate expressions - Comma separate the column names provided to
RETURNING
- Update docs to add syntax for setting multiple [k, v] pairs
ON CONFLICT
- Add support for
CREATE / DROP EXTENSION
- Add support for
DISTINCT ON
- Include
honeysql-posgres.format
directly intohoneysql-postgres.helpers
to avoid leaking therequire
to the consumer - Stop using lein and shift to deps exclusively
- Add CI and release/publish workflow
- Add support for testing all examples in the README as part of CI
- Add ILIKE, NOT ILIKE
- ADD EXCEPT and EXCEPT ALL
- Fix query-values priority
- Adds if-exist in drop table
- Add if-not-exist option to create-table
- Self-host ClojureScript port
- Add package.json for npm publishing
- Allows where clause to be used as an index predicate and update condition during upsert
- Breaking change (Revised implementation)
- over
- Added the following
- window
- Added the following
- alter-table
- add-column
- drop-column
- Added the following helpers and corresponding clauses
- partition by
- over (window function)
- create view
- create table
- drop table
- Added the following SQL function calls
- not
- primary-key
- foreign-key
- unique
- references
- constraint
- default
- nextval
- check
- Added upsert & returning clauses