# What's New?
## 6.2.1
Allow a QuickBuilder to be used wherever a QueryBuilder can be used.
## 6.2.0
Add the ability to [exclude all global scopes at once](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#global-scopes).
## 6.1.0
### Introducing the `asQuery` method
This method is similar to `asMemento`. You use it when the return format you want is an array of structs. `asQuery` will skip creating entities at all, instead returning the values straight from qb. This can result in a large performance boost depending on the number of records being returned. Additionally, `asQuery` supports returning the columns using the alias names and returning eager loaded entities.
Read more in the [`asQuery`](https://quick.ortusbooks.com/6.2.0/guide/serialization#asquery) docs.
## 6.0.0
* Add compatibility with ColdBox 7.
* Fixed a bug where once a virtual attribute was added to an entity it was added to all future entities of that same type.
* Dropped support for ColdBox 5.
## 5.3.3
Use correct nesting for where statements
## 5.3.2
Fixed retrieving `null` values from fields and relationships
## 5.3.1
* Special handling for Lucee generated keys
* Workaround for adobe\@2021 not supporting null values in param statements
* Upgrade to latest cfmigrations (v4.0.0)
## 5.3.0
Add a way to not fire events inside a callback using `withoutFiringEvents`.
## 5.2.11
Upgrade to qb 9
## 5.2.10
**HasOneOrManyThrough:** Fix too many joins for `has` and `whereHas`
## 5.2.9
**HasOneOrManyThrough:** Fixed applying of through constraints\
**BaseEntity:** Use wirebox to get the util to work in CommandBox
## 5.2.8
Fix bad link to Getting Started guide
## 5.2.7
Use existing builder when adding subselects
## 5.2.6
Update to latest mementifier (v3.0.0)
## 5.2.5
CommandBox compatibility
## 5.2.4
Force generated key to be an integer.
## 5.2.3
CommandBox-friendly injections using the `box` namespace.
## 5.2.2
Fixed regression where eager loading inside a relationship was broken.
## 5.2.1
Fixed accessing QuickBuilder from entities and relationships.
## 5.2.0
Add include and exclude arguments to [fill](https://quick.ortusbooks.com/6.2.0/guide/getting-started/creating-new-entities#fill) method.
## 5.1.3
Always return numeric value for [`AutoIncrementingKeyType`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#primary-key).
## 5.1.2
Add the builder to the `preInsert` method for [`ReturningKeyType`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#primary-key).
## 5.1.1
Set the table when creating new queries.
## 5.1.0
Added support for [single-table inheritance (STI)](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity/subclass-entities#single-table-inheritance-sti) with discriminated subclass entities.
## 5.0.0
In 5.0.0, we stepped up the performance of Quick in a major way. Entity creation is now over twice as fast as before.
### Performance Improvements
Average duration to create one entity:
| Engine | 4.2.0 | 5.0.0 |
| ----------- | ------- | ------- |
| adobe\@2018 | 7.65 ms | 3.71 ms |
| adobe\@2021 | 6.68 ms | 2.10 ms |
| lucee\@5 | 3.94 ms | 0.88 ms |
While the times may seem small, this is compounded for each entity you create. So, if you are retrieving 1000 entities, multiply each of these numbers by 1000 and you'll start to see why this matters.
This did introduce one breaking change from v4. See the [Upgrade Guide](https://quick.ortusbooks.com/6.2.0/upgrade-guide#5.0.0) for more information.
### New Features
* Added a new [`RowIDKeyType`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#primary-key) that will correctly set your primary key if your database only returns `ROWID` in the `queryExecute` response.
### Bug Fixes
* Fixed a null check in `isNullValue`.
* Fixed nulls coming back as strings in `JsonCast`.
## 4.2.0
* Add a [`simplePaginate`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#simplepaginate) pagination method for quicker performance when total records or total pages are not needed or too slow.
## 4.1.6
* Configure columns are no longer cleared when setting up a `BelongsToMany` relationship.
## 4.1.5
* Provide `initialThroughConstraints` for `hasOne` relationships (used in `*Through` relationships).
## 4.1.4
* Ignore orders when retrieving a relationship count.
## 4.1.1, 4.1.2
* Preserve casted value after saving an entity.
## 4.1.0
* Allow for [child entities,](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity/subclass-entities) including [discriminated entities.](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity/subclass-entities#discriminated-entities)
* Look up returning values by column name not by alias in the `ReturningKeyType`.
## 4.0.2
* Skip eager loading database call when no keys are found.
* Only apply `CONCAT` when needed in `*Through` relationships.
## 4.0.1
* Use `WHERE EXISTS` over `DISTINCT` when fetching relationships. `DISTINCT` restricts some of the queries that can be run.
## 4.0.0
{% hint style="success" %}
📹 [Watch a walkthrough of these changes on CFCasts.](https://cfcasts.com/series/whats-new-in-quick-4)
{% endhint %}
#### BREAKING CHANGES
* [Scopes](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects), [`whereHas`](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships#wherehas), and [`whereDoesntHave`](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships#wheredoesnthave) callbacks now automatically group where clauses when an `OR` combinator is detected.
#### Other Changes
* Dynamically add [relationship counts](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-counts) to a parent entity without loading all of the relationship.
* Give a helpful error message when trying to set relationship values before saving an entity, where applicable.
* Multiple bug fixes related to [subselects](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#subselects) and [querying relationships ](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships)when using `belongsToThrough`, `hasOneThrough`, or `hasManyThrough`.
## 3.1.7
* Correct jQuery link in test runner.
## 3.1.6
* Allow expressions in basic where clauses.
* Fix `delete` naming collision.
## 3.1.5
* Add an alias to `with` to QuickBuilder.
## 3.1.4
* Fix a stack overflow on nested relationship checks.
## 3.1.3
* Configured tables (`.from`) are now used for qualifying columns.
## 3.1.2
* Remove unnecessary nesting in compare queries.
## 3.1.1
* Fix [querying relationship methods](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships) when using "OR" combinators.
## 3.1.0
* Add support for JSON [casting](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#casts) using a new `JsonCast@quick` component.
## 3.0.4
* Compatibility updates for ColdBox 6
## 3.0.3
* Optimize [cast ](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#casts)caching
## 3.0.2
* Apply [custom sqltypes ](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#sql-type)during [eager loading](https://quick.ortusbooks.com/6.2.0/guide/relationships/eager-loading).
## 3.0.1
* Account for null values in [`fill`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/creating-new-entities#fill).
* Swap structAppend order for a Lucee bug in mementifier integration.
## 3.0.0
#### **BREAKING CHANGES**
*Please see the* [*Upgrade Guide*](https://quick.ortusbooks.com/6.2.0/upgrade-guide#3-0-0) *for more information on these changes.*
* Drop support for Lucee 4.5 and Adobe ColdFusion 11.
* Virtual Inheritance (using a `quick` annotation instead of extending `quick.models.BaseEntity`) has been removed. It was hardly used, and removing it allows us to simplify some of the code paths.
* `accessors="true"` is now required on every entity. This is similar to above where requiring it allows us to simplify the codebase immensely. A helpful error message will be thrown if `accessors="true"` is not present on your entity.
* The `defaultGrammar` mapping needs to be the full WireBox mapping, including the `@qb`, if needed.
* For instance, `MSSQLGrammar` would become `MSSQLGrammar@qb`.
* This will allow for other grammars to be more easily contributed via third party modules.
* [`HasManyThrough` relationships](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/hasmanythrough) now only accept a `relationships` parameter of relationship methods to walk to get to the intended entity.
* Attributes using `casts="boolean"` need to be updated to [`casts="BooleanCast@quick"`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#casts).
* Some method and parameter names have been changed to support composite keys. **The majority of changes will only affect you if you have extended base Quick components.** The full list can be found in the Upgrade Guide.
#### **Other Changes**
* [Bundle Mementifier](https://quick.ortusbooks.com/6.2.0/guide/serialization) for memento transformations.
* Use [asMemento](https://quick.ortusbooks.com/6.2.0/guide/serialization#asmemento) to automatically convert queries to mementos.
* Automatically-generated [API docs](https://apidocs.ortussolutions.com/#/coldbox-modules/quick/).
* Add error message for defaulting key values.
* Update to [qb 7.0.0](https://qb.ortusbooks.com/).
* Add a [belongsToThrough relationship](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/belongstothrough).
* Add a [HasOneThrough relationship](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/hasonethrough).
* [Custom Casts](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#casts) - using custom components to represent one or more attributes.
* [Ordering by relationship attributes](https://quick.ortusbooks.com/6.2.0/guide/relationships/ordering-by-relationships).
* [addSubselect](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#subselects) [improvements](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#using-relationships-in-subselects).
* Add a new QuickBuilder to better handle interop with qb.
* [Add `exists` and `existsOrFail` methods](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#existsorfail).
* Allow [custom](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#existsorfail) [error](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#firstorfail) [messages](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#findorfail) for `orFail` methods.
* Ensure `loadRelationship` doesn't reload existing relationships.
* Add multiple retrieve or new/create methods - [`firstWhere`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#firstwhere), [`firstOrNew`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#firstornew), [`firstOrCreate`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#firstorcreate), [`findOrNew`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#findornew), and [`findOrCreate`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#findorcreate).
* Add [`paginate`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#paginate) to Quick.
* Add [`is` and `isNot`](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity#comparing-entities) to compare entities.
* Allow [hydrating entities](https://quick.ortusbooks.com/6.2.0/guide/getting-started/retrieving-entities#hydrate) from serialized data.
* Allow returning default entities for null relations on [`HasOne`](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/hasone#withdefault), [`BelongsTo`](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/belongsto#withdefault), [`HasOneThrough`](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/hasonethrough#withdefault), and [`BelongsToThrough`](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/belongstothrough#withdefault) relationships.
* Query relations using [`has`](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships#has), [`doesntHave`](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships#doesnthave), [`whereHas`](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships#wherehas), and [`whereDoesntHave`](https://quick.ortusbooks.com/6.2.0/guide/relationships/querying-relationships#wheredoesnthave).
* Split `reset` into `reset` and `resetToNew` methods.
* Store the original attributes for later resetting.
* Use `parameterLimits` to eager load.
* Use a new entity each time on BaseService.
* Apply sql types for columns to `wheres`.
* Apply global scopes more consistently
* Correctly ignore key column when updating.
* Fix `hasRelationship` method to only return true for exact matches.
* Better handling of constrained relationships when eager loading.
* Convert aliases when qualifying columns.
* Add a better error message if `onMissingMethod` fails.
* Only retrieve columns for defined attributes.
* Cache entity metadata in CacheBox.
* Use attribute hash for checking `isDirty`.
## 2.5.0
* Define [custom collections](https://quick.ortusbooks.com/6.2.0/guide/collections) per entity.
## 2.4.0
* ~~Apply custom setters when hydrating from the database.~~ (Reverted in `2.5.3` for unintended consequences with things like password hashing.)
* [Query scopes can return any value.](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#scopes-that-return-values) This allows you to use scopes to perform query functions and return values. (If you do not want to return a custom value, return the `QueryBuilder` instance or nothing.)
* Improve error messages for not loaded entities.
* Return the correct memento with accessors on.
## 2.3.0
* [Option to ignore non-existent attributes](https://quick.ortusbooks.com/6.2.0/guide/getting-started/updating-existing-entities#update)
## 2.2.0
* [Relationship Fetch Methods](https://quick.ortusbooks.com/6.2.0/guide/relationships/retrieving-relationships) (`first` and `find` methods)
## 2.1.0
* [Subselect Helper](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#subselects)
* [Global Scopes](https://quick.ortusbooks.com/6.2.0/guide/getting-started/query-scopes-and-subselects#global-scopes)
* [saveMany](https://quick.ortusbooks.com/6.2.0/guide/relationships/relationship-types/hasmany#saveMany)
* Mapping foreign keys for relationships is now optional
* Either entities or primary key values can be passed to relationship persistance methods
* Relationships can also be saved by calling `"set" & relationshipName`
* [Virtual Inheritance](https://quick.ortusbooks.com/6.2.0/guide/getting-started/defining-an-entity) works on ColdBox 5.2+