v2.0.0

Breaking Changes

• QueryRepository insert() now returns void instead of an array. Use insertOne() if you need the ID returned #62
• QueryRepository insertOne() will now throw an exception if the primaryKey option is not passed and one cannot be inferred from the schema (i.e. if the schema is out-of-date or empty) #4
• db.functions has been replaced by the global DatabaseFunctions class. Replace db.functions.* with DatabaseFunctions.* and import from @riao/dbal #58
• Drivers must be upgraded to the dbal-2x compatible version
  • (Drivers only) - Driver builders should be updated to use the new this.sql object instead of this.sql string and this.params array #60

All Changes

• #43 Add support for table alias
• #24 Add "identified by" attribute to model repositories to allow dynamic or DRY primary key refs
• #25 Add accessor method/property to access a repository's table name
• #63 Add "not null" query condition
• #26 Add count method to QueryRepository by @DrewImm in #55
• #37 Add support for between to select query by @DrewImm in #56
• #35 Add support for select DISTINCT by @DrewImm in #57
• #66 Add DDL Builder access method for getting column types by @DrewImm in #69
• #58 Token usage/implementations are inconsistent by @DrewImm in #59
• #60 SQL builder should be separated from query/ddl/schema builders by @DrewImm in #61
• #62 Only insertOne() should return ID; insert in bulk should not by @DrewImm in #65
• Issue 62 by @DrewImm in #68
• #67 SQLite Prep - Add DDLBuilder::createTablePrimaryKeys() to allow override by @DrewImm in #72
• #70 SQLite Prep - Queries may return no results by @DrewImm in #71
• #64 SQL Syntax Error - Order By with Limit by @DrewImm in #73
• #4 Running query.insert with an empty schema returns undefined id by @DrewImm in #74

Full Changelog: v1.1.3...v2.0.0