What's Changed

• fix phpDoc and broken return type in Common/Select.php by @pavarnos in #110
• insert->col() and update->col() use variable argument lists by @pavarnos in #111
• Docs structure and add changelog by @harikt in #113
• make $bind parameters explicit in WhereInterface and in having() clauses by @pavarnos in #114
• fix scrutinizer messages by @pavarnos in #117
• move copy/pasted where() / orWhere() to WhereTrait by @pavarnos in #116
• add missing public methods to SelectInterface and related. by @pavarnos in #112
• add Insert::orReplace by @pavarnos in #115
• improve test coverage by @pavarnos in #119
• move copy/pasted limit()/offset() code to traits by @pavarnos in #120
• add “composer test” command to composer.json by @pavarnos in #123
• Extract builder logic to separate classes by @pmjones in #131
• 3.x quoter by @pmjones in #132
• Remove SubSelect interface, typehint on SelectInterface instead by @pmjones in #133
• 3.x: Named placeholders only for where() et al. conditions by @pmjones in #134
• Fixes #125 by @harikt in #135
• Support 'grouping' of where() and having() conditions by @pmjones in #136
• Only fall back to common quoter when DB-specific quoter doesn't exist by @djmattyg007 in #141
• Add "table dot star" assertion to quoter test by @djmattyg007 in #140
• Add missing closing ``` in docs/select.md by @johnchen902 in #144
• Make travis use trusty by @jakejohns in #148
• Drop HHVM support v3.x by @odan in #153
• Test newer PHP versions on CI by @Bilge in #169
• Explain how to bind IN conditions by @afilina in #175
• fix minor typo in instantiation.md by @cammytown in #180
• improve select.md orderBy example by @cammytown in #181
• minor typo in select.md by @cammytown in #182
• fixes #178 by @pmjones in #179
• Enable PHP 5.6-8.1 compat in 3.x by @koriym in #195
• Fix typos by @koriym in #196
• Add to composer ext-pdo_sqlite which required for tests by @maximTarleckiy in #174
• Fix types in phpdoc by @koriym in #197
• Support inline array for condition by @syrm in #162
• Refactor #162 by @koriym in #198
• Add ignore() method to common Insert class by @maximTarleckiy in #173
• Fix deprecated test method by @koriym in #199
• Specify composer version to run up to PHP 7.1 with CI by @koriym in #202
• Enable PHP 8.2 compat by @koriym in #204

New Contributors

• @djmattyg007 made their first contribution in #141
• @johnchen902 made their first contribution in #144
• @jakejohns made their first contribution in #148
• @Bilge made their first contribution in #169
• @afilina made their first contribution in #175
• @cammytown made their first contribution in #180
• @maximTarleckiy made their first contribution in #174
• @syrm made their first contribution in #162

Full Changelog: 2.7.1...3.0.0

What's Changed

• [BUG] Fix bad use of strripos by @auroraeosrose in #206 , cherry picked and merged to 2.x via #207

Full Changelog: 2.8.0...2.8.1

What's Changed

• Splitting array parameters into multiple parametres for fix PDO excecution error "Array to string conversion" by @PHPCraftdream in #127
• Added phpunit via composer by @syndicateSoftware in #128
• Drop HHVM support v2.x by @odan in #154
• Add WHERE IN example by @odan in #146
• Correct preg_split call by @srjlewis in #190
• Update ci to support from php 5.4 to 8.1 by @harikt in #203

New Contributors

• @PHPCraftdream made their first contribution in #127
• @syndicateSoftware made their first contribution in #128
• @srjlewis made their first contribution in #190

Full Changelog: 2.7.1...2.8.0

What's Changed

• fix phpDoc and broken return type in Common/Select.php by @pavarnos in #110
• insert->col() and update->col() use variable argument lists by @pavarnos in #111
• Docs structure and add changelog by @harikt in #113
• make $bind parameters explicit in WhereInterface and in having() clauses by @pavarnos in #114
• fix scrutinizer messages by @pavarnos in #117
• move copy/pasted where() / orWhere() to WhereTrait by @pavarnos in #116
• add missing public methods to SelectInterface and related. by @pavarnos in #112
• add Insert::orReplace by @pavarnos in #115
• improve test coverage by @pavarnos in #119
• move copy/pasted limit()/offset() code to traits by @pavarnos in #120
• add “composer test” command to composer.json by @pavarnos in #123
• Extract builder logic to separate classes by @pmjones in #131
• 3.x quoter by @pmjones in #132
• Remove SubSelect interface, typehint on SelectInterface instead by @pmjones in #133
• 3.x: Named placeholders only for where() et al. conditions by @pmjones in #134
• Fixes #125 by @harikt in #135
• Support 'grouping' of where() and having() conditions by @pmjones in #136
• Only fall back to common quoter when DB-specific quoter doesn't exist by @djmattyg007 in #141
• Add "table dot star" assertion to quoter test by @djmattyg007 in #140
• Add missing closing ``` in docs/select.md by @johnchen902 in #144
• Make travis use trusty by @jakejohns in #148
• Drop HHVM support v3.x by @odan in #153
• Test newer PHP versions on CI by @Bilge in #169
• Explain how to bind IN conditions by @afilina in #175
• fix minor typo in instantiation.md by @cameronsteele in #180
• improve select.md orderBy example by @cameronsteele in #181
• minor typo in select.md by @cameronsteele in #182
• fixes #178 by @pmjones in #179
• Enable PHP 5.6-8.1 compat in 3.x by @koriym in #195
• Fix typos by @koriym in #196
• Add to composer ext-pdo_sqlite which required for tests by @maximTarleckiy in #174
• Fix types in phpdoc by @koriym in #197
• Support inline array for condition by @syrm in #162
• Refactor #162 by @koriym in #198
• Add ignore() method to common Insert class by @maximTarleckiy in #173
• Fix deprecated test method by @koriym in #199
• Specify composer version to run up to PHP 7.1 with CI by @koriym in #202

New Contributors

• @djmattyg007 made their first contribution in #141
• @johnchen902 made their first contribution in #144
• @jakejohns made their first contribution in #148
• @Bilge made their first contribution in #169
• @afilina made their first contribution in #175
• @cameronsteele made their first contribution in #180
• @maximTarleckiy made their first contribution in #174
• @syrm made their first contribution in #162

Full Changelog: 2.7.1...3.0.0-alpha1

Hygiene release: update README.

• [DOC] Numerous docblock and README updates.
• [ADD] Add various Select::reset*() methods. Fixes #84, #95, #94, #91.
• [FIX] On SELECT, allow OFFSET even when LIMIT not specified. Fixes #88.
• [FIX] On SELECT, allow join*() before from*(). Joins-before-from are added
  to the first from. If no from is ever added, the joins will never be built
  into the statement. Fixes #69, #90.
• [BRK] Bumped the minimum version to PHP 5.3.9 (vs 5.3.0). Fixes #74. This is
  to address a language-level bug in PHP. Technically I think this is a BC
  break, but I hope it is understandable, given that PHP 5.3.x is end-of-life,
  and that Aura.SqlQuery itself simply will not operate on versions earlier
  than that. Updated README to reflect the version requirement.

• (DOC) Docblock and README updates; in particular, add an @method getStatement() to the QueryInterface for IDE auto-completion.
• (ADD) Select::hasCols() reports if there are any columsn in the Select.
• (ADD) Select::getCols() gets the existing columns in the Select.
• (ADD) Select::removeCol() removes a previously-added column.
• (FIX) Select::reset() now properly resets the table refs for a UNION.
• (FIX) Select::forUpdate() is now fluent.

• Docblock and README updates
• The Common\Select class, when binding values from a subselect, now checks for
  instanceof SubselectInterface instead of self; the Select class now
  implements SubselectInterface, so this should not be a BC break.
• Subselects bound as where/having/etc conditions should now retain ?-bound
  params.

This release modifies the testing structure and updates other support files.

This release fixes Insert::addRows() so that adding only one row generates the correct SQL statement.