UPDATE ALL THE THINGS!!

• BREAKING CHANGES:
  • Now only supports Node 4 and later
  • Removed query.emitted()
  • Removed query.run() alias for query.exec()
  • query.exec() now always uses the connection.query function instead of connection.execute.
• New: Casting a query object to a string now produces a query with escaped values.
• Fixed: query.clone() will now properly clone all attributes.
• Dependencies:
  • Replaced lodash.assign with ES6 Object.assign
  • Replaced lodash.clone with lodash.clonedeep.
  • Updated lodash.mapvalues to 4.5.0
  • Updated proxmis to 1.0.0
  • Now using the sqlstring package to handle data escapement
• Internal changes:
  • Tests are now built using node-tap instead of nodeunit
  • Library is now linted using eslint

Null-ed

• Fixed a bug that would create a malformed query when inserting or updating a null value.

Dated

• Date objects are now converted to MySQL DATETIME using the timezone on the date instead of always being UTC.

Misjoined

• Fixed a bug where using a raw subquery as a join target could lose part of the subquery.

Yo Dawg

Note, due to a mispublish, 1.0.0 never existed

• Added Multi-Insert Mode
  • Causes Queryize to create insert queries in the format of INSERT INTO table (columnA, columnB) VALUES (valueA, valueB), supporting multiple rows of data to be inserted.
  • Activated first time query.addRow is used.
• Added support for REPLACE INTO queries via query.replace() as an alternative to query.insert()
• Added support for passing raw query functions as query.set() values
  • Example: `query.set('dts', {raw:'NOW()'});
• Added query.addColumn to append extra columns outside of the query.column full set.
• Fixed query.set() not properly overwriting a previously defined key/value pair.
• INTERNAL: Query builders can now return a fully formed query object instead of a string.

Extensibility Refactor

• Major internal refactor to make the query object more externally extensible
  • Query state is now stored on this._attributes instead of in a local variable.
  • queryize.fn now contains the prototype of the queryize query object. See lib/mutators.js for the contents.
• Added query.clone() to duplicate a query state inline
• Changed query.deleet() to query.delete()
• Switched to using lodash clone and assign functions instead of local versions.
• Added query.disableBoundParameters and deprecated query.useBoundParameters
• Fixed several V8 optimization killers
• Fixed bugs in query.limit() and query.distinct()
• Fixed edge case in query.where()
• Increased test coverage
• Improved documentation

v0.2.0

• Added support for node-mysql2 connection.execute() functions. Prefers over connection.query()
• query.exec() now extends the node-mysql(2) query emitter object with .then() and .catch(), allowing use as a promise.
• Lots and lots of new documentation in code
• Switched to using a custom dox based documentation generator
• Added Travis-CI testing
• Launched http://queryizejs.com