query

Changed

• Bump hectororm/connection version to 1.0.0-beta7

Changed

• INSERT syntax to be conformed to SQL

Removed

• Assignment component on QueryBuilder class

Added

• "Ignore" parameter for inserts to the query builder

Added

• Ignore parameter for inserts

Changed

• The distinct parameter is reset when select is reset

Added

• The distinct parameter can be a closure

Changed

• Quote aliases in components

Added

• QueryBuilder::insert() accept a statement in assignment

Changed

• Compatibility with hectororm/connection version 1.0.0-beta6

Added

• Bind parameters in builder and queries objects

Changed

• QueryBuilder implements StatementInterface
• Use BinParamList object instead array

Fixed

• Array cast of sub values for binding
• Count with "having" conditions
• Count with DISTINCT selection

Added

• New helper methods to build queries: whereNull(), whereNotNull(), havingNull(), havingNotNull()

Added

• New helper methods to build queries: whereContains(), whereStartsWith(), whereEndsWith(), havingContains(), havingStartsWith(), havingEndsWith()

Changed

• Stop to beautify and indent... SQL queries

Removed

• @package attributes from PhpDoc

Fixed

• Count method of query builder with grouped select

Initial development.