github coldbox-modules/qb v8.7.0-beta.1

latest releases: v9.11.1, v9.11.0, v9.10.3...
pre-release3 years ago

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.

Don't miss a new qb release

NewReleases is sending notifications on new releases.