v8.7.2

fix

• QueryUtils: Add better null handling to inferSqlType
  (1f11650)

v8.7.1

fix

• QueryBuilder: Correctly format columns being updated
  (a32bfb5)

v8.7.0

chore

• Release: Fix artifact commit process during release
  (2c7d3eb)
• CI: Remove ColdBox as a test dependency
  (9fa95ca)
• CI: Test with full null support (98b0df9)

feat

• QueryBuilder: Allow updates with subselects (af82f71)
• QueryBuilder: Allow JOINS in UPDATE statements (0a89175)
• QueryBuilder: Allow expressions in value and values (60d131e)
• QueryBuilder: Add an upsert method (13debdd)

fix

• Expressions: Better Expression support in HAVING (7b1096f)
• Aggregates: Use default values via COALESCE (ab181e2)
• Aggregates: Provide default values for sum and count if no records are returned (4ce89ac)
• Aggregates: Allow any value to be returned from withAggregate (5323e39)
• Pagination: Handle group by and havings in pagination queries (4a4428f)

other

• *: v8.7.0-beta.2
  (62705cd)
• *: v8.7.0-beta.1
  (13feb20)

v8.7.0-beta.2

Bug Fixes

• Better support for raw expressions in HAVING clauses, both the column as well as the value.

v8.7.0-beta.1

New Features and Improvements

• Add an upsert method. upsert can update or insert multiple records at once depending on if a column is matched.
• Allow expressions in value and values. Also add a valueRaw and valuesRaw helper method to make that pattern more ergonomic.
• Allow JOIN statements in UPDATE statements. (This is not supported on Oracle.)
• Allow updates with subselects using closures or builder instances.

Bug Fixes

• Better handling of group by and having clauses in pagination queries.
• Allow any value to be returned from aggregates including strings, numbers, and dates.
• Provide default values for sum and count if no records are returned.
• Test in CI with full null support.

v8.6.1

fix

• QueryBuilder: Correctly wrap CTE expressions (f55a224)

v8.6.0

feat

• SchemaBuilder: Add default options to constructor (355c28a)

v8.5.0

chore

• SchemaBuilder: Add types to SchemaBuilder classes (57e9c7d)

docs

• QueryBuilder: Add missing docblocks
  (e6327d1)

feat

• QueryBuilder: Add support for whereNotLike
  (b7deb9a)
• QueryUtils: Automatically add scale to bindings when needed (0a92cea)
• SchemaBuilder: Add computed / virtual column support (1531fed)
• QueryBuilder: Add a reset method (f39089b)
• Locks: Add locking helpers to qb (b986211)

fix

• OracleGrammar: Fix typo for argumentCollection
  (dce8e15)
• OracleGrammar: Only use batch insert syntax when needed (9707f03)
• QueryBuilder: Distinct and Aggregate queries compile correctly
  (0479eec)
• QueryBuilder: Pass options to exists call in updateOrInsert
  (f07d97e)
• Aggregates: Correctly return aggregate values (50f315a)

v8.4.9

chore

• CI: Swap to main branch
  (6c94e46)

v8.4.8

chore

• Utils: Remove injection for QueryUtils (bac94a5)