2.6.1126

• Address #524 by adding example of {:nest ..} in :union clause reference docs.
• Address #523 by expanding examples in README Functions to show aliases.
• Address #522 by supporting metadata on table specifications in :from and :join clauses to provide index hints (SQL Server).
• Address #521 by adding initial experimental support for an XTDB dialect.
• Address #520 by expanding how :inline works, to support a sequence of arguments.
• Fix #518 by moving temporal clause before alias.
• Address #495 by adding formatv macro (.clj only!) -- and removing the experimental formatf function (added for discussion in 2.4.1045).
• Implemented CREATE INDEX #348 via PR #517 @dancek.
• Mention :not-in explicitly in the documentation.
• Code cleanup per clj-kondo.

2.5.1103

• Address #515 by:
  • Quoting entities that start with a digit but are otherwise alphanumeric. Note that entities that are all digits (optionally including underscores) will still not be quoted as in previous releases,
  • Adding a new :quoted-always option allows users to specify a regex that matches entities that should always be quoted (stropped) regardless of the value of :quoted (such as reserved words that you have used as column or table names).
• Address #513 by:
  • Ignoring :file, :line, :column, :end-line, and :end-column metadata keys (previously only :line and :column were ignored),
  • Adding an :ignored-metadata option to allow additional keys to be ignored.

2.5.1091

• Address #512 by adding support for subqueries in the :array special syntax (for BigQuery and PostgreSQL). This also adds support for metadata on the :select value to produce AS STRUCT or DISTINCT.
• Address #511 by adding support for BigQuery CREATE OR REPLACE.
• Address #510 by adding initial support for an NRQL dialect.
• Fix #509 by checking for ident? before checking keyword/symbol.

2.4.1078

• Address #507 by clarifying formatting of :cast in Special Syntax.
• Fix #505 by rewriting the helper merge function to handle both keywords and symbols properly.
• Address #503 by adding :at-time-zone special syntax.
• Address #504 for BigQuery support, by adding special syntax for ignore/respect nulls, as well as new :distinct and :expr clauses to allow expressions to be qualified with SQL clauses. The latter will probably be useful for other dialects too.
• Update tools.build to 0.9.6 (and get rid of template/pom.xml in favor of new :pom-data option to b/write-pom).

2.4.1066

• Add :select with function call and alias example to README (PR #502 @markbastian).
• Address #501 by making INSERT INTO (and REPLACE INTO) use the :columns or :values clauses to produce column names (which are then omitted from those other clauses).
• Address #497 by adding :alias special syntax.
• Address #496 by adding :overriding-value option to :insert clause.
• Address #407 by adding support for temporal queries (see FROM in SQL Clause Reference).
• Address #389 by adding examples of [:only :table] producing ONLY(table).
• Add :create-or-replace-view to support PostgreSQL's lack of IF NOT EXISTS for CREATE VIEW.
• Attempt to clarify the formatting behavior of the :values clause when used to produce column names.
• Update tools.build to 0.9.5 (and remove :java-opts setting from build/run-task)

2.4.1045

• Fix #494 by supporting expressions in :on-conflict instead of just entities.
• Address #493 by clarifying use of :values in CTEs (using :with).
• Address #489 by adding more examples around :update.
• Attempt to improve honey.sql.helpers namespace docstring (by adding a note from the relevant Getting Started section).
• Update dev/test dependencies.

2.4.1033

• Tentative ClojureCLR support.
• Improve on-conflict helper docstring #490 @holyjak.

2.4.1026

• Fix #486 by supporting ANSI-style INTERVAL syntax.
• Fix #485 by adding :with-ordinality "operator".
• Fix #484 by adding TABLE to TRUNCATE.
• Fix #483 by adding a function-like :join syntax to produce nested JOIN expressions.
• Update tools.build; split alias :test/:runner for friendlier jack-in UX while developing.

2.4.1011

• Address #481 by adding more examples around :do-update-set.
• Address #480 by clarifying the general relationship between clauses and helpers.
• Address #448 by adding a new section with hints and tips for database-specific syntax and solutions.

2.4.1006

• Fix #478 by handling :do-update-set correctly in the upsert helper and by handling parameters correctly in the :do-update-set formatter.
• Fix #476 by adding support for multiple arguments to :raw, essentially restoring 1.x functionality (while still allowing for embedded vectors as expressions, introduced in 2.x).