# Changes

This file is a manually maintained list of changes for each release. Feel free
to add your changes here when sending pull requests. Also send corrections if
you spot any mistakes.

## v0.9.0 (2015-02-05)

* Added this history file
* Added the ability to do `SELECT DISTINCT` queries
* We're doing better escaping of identifiers now
* Added the ability to use table/view prefixes directly (ex. `select * from users u`)
* Added the ability to do `OR WHERE` statements with `or_where()` method.
* Added the ability to do `LIKE` statements directly (new methods: `like()`, `not_like()`, `or_like()`, `or_not_like()`)
* Restored ability to do `WHERE IN(...)` statements by passing an array as the second param to `where()`
* Added the ability to do `[OR] WHERE [NOT] IN(...)` statements directly (new methods: `where_in()`, `or_where_in()`, `where_not_in()`, `or_where_not_in()`)
* Added the ability to do `FROM` statements directly for `SELECT` and `DELETE` queries (new method: `from()`) (ex. db.from('foo').get(() => ...))
* Identifiers will now be properly escaped in `JOIN` statements.
* Added the ability to call `get_where()` as a shorthand to `get()` and `where()` (ex. `db.get_where('table',{foo: 'bar'},() => ...);`)
* Added the ability to call `select_min()`, `select_max()`, `select_avg()`, and `select_sum()`.
* Significanly improved security, helping to prevent SQL injection attacks.
* Added ability to do `OR HAVING` statements with `or_having()` method
* Added ability to add an offset directly without using the `limit()` method by using the `offset()` method.
* Added ability to set `SET` values for updates and inserts using the `set()` method.
* `UPDATE` statements now support `ORDER BY` clauses which can be added to the query using the `order_by()` method.
* The `update()` method's 3rd parameter can now either be the callback (as always) or a `WHERE` clause (ex. 'foo = "bar"' or {foo:'bar', id: 3}). If a where clause is provided, the callback is now the 4th parameter. This change is fully backwards-compatible with the previous version of this module.
* New package dependencies (for testing): chai and mocha.
* Tests have been written for better-ensuring future enhancements and fixes to not break functionality
* Library has been broken into 3 objects to allow for prpoer testing. This won't affect the API and is fully-backwards compatible with the previous version.
* Officially announcing that how third parameter of the `where()` method works is deprecated... starting with v1.0.0, third param will be `(bool) escape` and not `(bool) isRaw`. So, all calls to this method using the 3rd parameter will, in future, have to be changed by converting `true` to `false` and vice versa. This is so that we have a consistent API throughout the library.
* Name officially changed to node-mysql-querybuilder.
* Author officially changed to Kyle Farris due to the substantial changes to this fork and Martin Tajur demoted to primary contributor (thanks for the great starting place Martin!!)
* Name of internal methods and properties have been normalized to use the "lower_case" syntax.
* Dependency for node-mysql upgraded to 2.5.
* travis-ci functionality added to repository
* Added public `escape()` method
* Added funtional `update_batch()` method.
* Added `truncate()` and `empty_table()` methods.

## v0.15.0 (2017-04-27)

* Fixed and documented the escape property of the `join` method.