* Address [#596](https://github.com/seancorfield/honeysql/issues/596) by removing `#'` Var references from all production code. This meant making a couple of private functions public, but marking them `^:no-doc` to indicate they are not part of the public API. * Update dev/test deps.

* Address [#589](https://github.com/seancorfield/honeysql/issues/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.

* Remove stray `tap>` call via PR [#587](https://github.com/seancorfield/honeysql/pull/587) by [Julien Vincent](https://github.com/julienvincent). * Fix [#586](https://github.com/seancorfield/honeysql/issues/586) by reusing some of the `format-order-by` logic in `format-create-index` to provide column ordering. * Fix [#585](https://github.com/seancorfield/honeysql/issues/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`.

* Address [#582](https://github.com/seancorfield/honeysql/issues/582) by adding PostgreSQL `=>` named parameter operator via `:=>`. * Address [#579](https://github.com/seancorfield/honeysql/issues/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](https://github.com/seancorfield/honeysql/issues/576) by fixing single argument `where` logic. * Update `test-doc-blocks` (and use Clojure 1.12.1 during test generation).

* Address [#575](https://github.com/seancorfield/honeysql/issues/575) by adding support for parameters in inline XTQL queries. * Address [#574](https://github.com/seancorfield/honeysql/issues/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](https://github.com/seancorfield/honeysql/pull/573) [@alexander-yakushev](https://github.com/alexander-yakushev). * Address [#572](https://github.com/seancorfield/honeysql/issues/572) by adding `[:xtql ...]` special syntax for inline XTQL queries (for XTDB). * Fix [#571](https://github.com/seancorfield/honeysql/issues/571) by allowing `:order-by` to take an empty sequence of columns (and be omitted). * Address [#440](https://github.com/seancorfield/honeysql/issues/440) by supporting multiple tables in `:truncate`. * Support `USING HASH` as well as `USING GIN`. * Update dev/build deps.

* 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](https://github.com/seancorfield/honeysql/issues/561).

* Address [#568](https://github.com/seancorfield/honeysql/issues/568) by adding `honey.sql/semicolon` to merge multiple SQL+params vectors into one (with semicolons separating the SQL statements). * Address [#567](https://github.com/seancorfield/honeysql/issues/567) by adding support for `ASSERT` clause. * Address [#566](https://github.com/seancorfield/honeysql/issues/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`).

* Fix autoboxing introduced in 2.6.1270 via PR [#564](https://github.com/seancorfield/honeysql/pull/564) [@alexander-yakushev](https://github.com/alexander-yakushev).