v3.0.0

Breaking Changes

• #87 Misleading Behavior in insertOne Method with Multiple Records
  • insertOne() records key has changes to record
• #89 Refactor expression/placeholder logic
  • Imports to @riao/dbal/conditions have moved to:
    • and, or, not: @riao/dbal/expression
    • comparisons (less than, equals, not equal, etc.): @riao/dbal/comparison
  • Subqueries must now be wrapped in new Subquery()
  • columnName() is now identifier(), although the former has been left in for backwards compatibility
  • 'and' and 'or' strings are no longer allowed in expressions, and must be replaced with and and or imported from @riao/dbal/expression

New Features

• #45 Group By
• #89 Join on expression
• #89 Select column from expression
• #89 Select where expression
• #89 Select where KV expression
• #89 Insert record w/ expression
• #89 Update record w/ expression
• #89 Delete record w/ expression
• #89 Default column value from function/expression/etc.

Fixes

• #89 Refactor expression/placeholder logic by @DrewImm in #90
• #80 Running findOne before database init complains about unknown PK i… by @DrewImm in #93

All Changes

• #89 Refactor expression/placeholder logic by @DrewImm in #90
• #87 Misleading Behavior in insertOne Method with Multiple Records by @DrewImm in #91
• #45 Add support for group-by by @DrewImm in #92
• #80 Running findOne before database init complains about unknown PK i… by @DrewImm in #93

Full Changelog: v2.0.0...v3.0.0