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.