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).

2.4.1002

• Address #474 by adding dot-selection special syntax.
• Improve docstrings for PostgreSQL operators via PR #473 @holyjak.
• Address #471 by supporting interspersed SQL keywords in function calls.
• Fix #467 by allowing single keywords (symbols) as a short hand for a single-element sequence in more constructs via PR #470 @p-himik.
• Address #466 by treating [:and] as TRUE and [:or] as FALSE.
• Fix #465 to allow multiple columns in :order-by special syntax via PR #468 @p-himik.
• Fix #464 by adding an optional type argument to :array via PR #469 @p-himik.
• Address #463 by explaining :quoted nil via PR #475 @nharsch.
• Address #462 by adding a note in the documentation for set operations, clarifying precedence issues.

2.4.980

• Fix #461 -- a regression introduced in 2.4.979 -- by restricting unary operators to just +, -, and ~ (bitwise negation).

2.4.979

• Address #459 by making all operators variadic (except := and :<>).
• Address #458 by adding registered-*? predicates.

2.4.972

• Address #456 by allowing format to handle expressions (like 1.x could) as well as statements. This should aid with migration from 1.x to 2.x.

2.4.969

• Fix #454 by allowing - to be variadic.
• Address #452 by adding :replace-into to the core SQL supported, instead of just for the MySQL and SQLite dialects (so the latter is not needed yet).
• Address #451 by adding a test for it, showing how :nest produces the desired result.
• Address #447 by updating GitHub Actions and dependencies.
• Address #445 and #453 by adding key/constraint examples to CREATE TABLE docs.

2.4.962

• Fix set-options! (only :checking worked in 2.4.947).
• Fix :cast formatting when quoting is enabled, via PR #443 duddlf23.
• Fix #441 by adding :replace-into to in-flight clause order (as well as registering it for the :mysql dialect).
• Fix #434 by special-casing :'ARRAY.
• Fix #433 by supporting additional WITH syntax, via PR #432, @MawiraIke. [Technically, this was in 2.4.947, but I kept the issue open while I wordsmithed the documentation]
• Address #405 by adding :numbered option, which can also be set globally using set-options!.