fixes #5331

fixes #5147
[ci skip]

fixes #5147

Fixes #5106: Refactored query caching to not load cache component when query caching is not used at all.

Fixes #3197: Using `ActiveQuery::indexBy()` may cause relational AR queries to generate incorrect relational results

Fixes #3725: Fixed the bug that the filtering condition used in relation definition was ignored when calling `ActiveRecord::unlinkAll()`

Fixes #4938: When `yii\db\ActiveQuery` is used to build sub-queries, its WHERE clause is not correctly generated

Handling $query->joinWith called inside of other $query->joinWith within Closure (called inside Closure). Ex.: ```php $query->joinWith( [ 'rel1' => function($query) { $query->joinWith( [ 'rel2' => function($query) { // ... } ] ); } ] ); ```

fixes #4931

New syntax:

```
[link to guide](guide:file-name.md)
[link to guide](guide:file-name.md#subsection)
```

fixes #4719

- do not allow boolean values for integer columns
- use native boolean type with boolean values
- removed workaround that turned out to be wrong when schema and values
  are used correctly. Workaround resulted from wrong usage of boolean
  values before.

fixes #4672

Fixes #4697: MSSQL query builder does not work for newer MSSQL versions when LIMIT is used without ORDER BY

Fixes #4607: AR model will throw an exception if it does not have a primary key to avoid updating/deleting data massively

[ci skip]

Fixes #4586: Signed bigint and unsigned int will be converted into integers when they are loaded from DB by AR

also fixed an issue with default value loading of bool columns.

fixes #3489, fixes #4085, fixes #3920
related to #4672

fixes #4654

Fixes #4644: Added `\yii\db\Schema::createColumnSchema()` to be able to customize column schema used

Added support for arbitrary operators to Query::filterWhere, added support for arbitrary operators to Sphinx extension