2.7.1350

• Address #589 by adding support for the QUALIFY clause (non-ANSI, but supported by several databases).
• Note that HoneySQL does not support the double-colon :: syntax for casts: you must use the CAST syntax instead, i.e., [:cast :a :int] to produce CAST(a AS INT) instead of a::INT.
• Update dev/test deps.

2.7.1340

• Remove stray tap> call via PR #587 by Julien Vincent.
• Fix #586 by reusing some of the format-order-by logic in format-create-index to provide column ordering.
• Fix #585 by checking for the symbol where (as well as the keyword :where).
• Assume bb for testing/building; add bb.edn; switch GitHub Actions to use bb.

2.7.1325

• Address #582 by adding PostgreSQL => named parameter operator via :=>.
• Address #579 by adding :call special syntax to force a function call based on an expression.
• Add support for MySQL USE INDEX on FROM via metadata.
• Fix #576 by fixing single argument where logic.
• Update test-doc-blocks (and use Clojure 1.12.1 during test generation).

2.7.1310

• Address #575 by adding support for parameters in inline XTQL queries.
• Address #574 by adding honey.sql/*nest-infix* which can be bound to false to prevent infix operators (such as :and) from nesting their arguments, i.e, wrapping them in ( .. ). If precedence matters in your expressions, this will produce incorrect SQL. It is intended for specific, limited query dialects (such as Google Ads Queries).
• More performance optimizations via PR #573 @alexander-yakushev.
• Address #572 by adding [:xtql ...] special syntax for inline XTQL queries (for XTDB).
• Fix #571 by allowing :order-by to take an empty sequence of columns (and be omitted).
• Address #440 by supporting multiple tables in :truncate.
• Support USING HASH as well as USING GIN.
• Update dev/build deps.

2.7.1295

• Address #570 by adding :.:. as special syntax for Snowflake's JSON path syntax, and :at as special syntax for general [..] path syntax.
• Drop support for Clojure 1.9 #561.

2.6.1281

• Address #568 by adding honey.sql/semicolon to merge multiple SQL+params vectors into one (with semicolons separating the SQL statements).
• Address #567 by adding support for ASSERT clause.
• Address #566 by adding IS [NOT] DISTINCT FROM operators.
• Add examples of :alias with :group-by (syntax is slightly different to existing examples for :order-by).

2.6.1270

• Fix autoboxing introduced in 2.6.1270 via PR #564 @alexander-yakushev.

2.6.1267

• Support expressions in WITH clauses via PR #563 @krevedkokun.
• More performance optimizations via PRs #560 and #562 @alexander-yakushev.
• Fix two broken links to the HoneySQL web app via PR #559 @whatacold.
• Make SQL Server dialect auto-lift Boolean values to parameters since SQL Server has no TRUE / FALSE literals.
• Fix bug in DEFAULT values clause (that omitted some values).

2.6.1243

• Address #558 by adding :patch-into (and patch-into helper) for XTDB (but in core).
• Address #556 by adding an XTDB section to the documentation with examples.
• Address #555 by supporting SETTING clause for XTDB.
• Replace assert calls with proper validation, throwing ex-info on failure (like other existing validation in HoneySQL).
• Experimental :xtdb dialect removed (since XTDB no longer supports qualified column names).
• Update dev/test deps.

2.6.1230

• Fix #553 by adding :not-between as special syntax via PR #554 @plooney81
• Fix #552 by changing the assert-on-load behavior into an explicit test in the test suite.
• Fix #551 by supporting multiple WINDOW clauses.
• Fix #549 by using :bb conditionals to support Babashka (and still support Clojure 1.9.0), and add testing against Babashka so it is fully-supported as a target via PR #550 @borkdude
• Address #532 by adding support for XTDB SQL extensions ERASE, EXCLUDE, OBJECT, RECORD, RECORDS, and RENAME, along with inline hash maps (as records) and :get-in for object navigation, and starting to write tests for XTDB compatibility.