Please refer to the following release notes when upgrading your version of BackboneSQL.
- Fixed a bug with $unique which caused incorrect sql.
- Fixed a bug which caused queries of the form {$or: [{'jsonField.name': value}, ...]} to be created with 'and' instead of 'or'.
- Queries on related models no longer require a full join, so $limit and $offset work (thanks @kenhg!)
- Accept related fields in $select (provided they are included either with $include or a query on that relation) ({$select: ['id', 'users.profile_id'})
- Add support for related json arrays ({'relation.jsonField': 'something'})
- Fixed a bug with $include
- Use full table.column names for sort fields
- Use reverse_model_type to get related model in case reverse_relation isnt present
- Handle queries spanning multiple relations, e.g. {'profiles.users.email': 'smth@example.com'}
- A join will be made on each relation in the query chain.
- Potentially breaking change: All ids are now parsed into strings by default.
- This means that all ids, whether they came from backbone-sql or backbone-mongo, will be of the same type.
- Support $in for queries on jsonb arrays
- Basic support for json queries in arrays
- Bug fix for missing callback
- Bug fix $exists checks for nulls
- improve row counts for $unique
- Bug fix for join tables
- Bug fix for patch remove
- Added dynamic and manual_ids capabilities
- Added unique capability
- Upgraded to BackboneORM 0.6.x
- Simplified database_tools and made compatible with the latest knex.
- Update knex due to bluebird dependency breaking.
- Fix for $ne: null in find queries
- Compatability fix for Backbone 1.1.1
- Knex bug fix for count
- Lock Backbone.js to 1.1.0 until new release compatibility issues fixed
- Updated to latest Knex (still outstanding problems with consistent Date support in Knex - not all mysql sqlite tests passing for dates)
- $nin bug fix
- $nin support
- Handle null hasMany relations in _joinedResultsToJSON
- db.ensureSchema not complain when running lots of operations
- Initial release