override only mssql and sqlite QueryBuilder; throw an exception for composite in condition with a subquery

docs/guide-ja/structure - review completed [ci skip]

Docs guide ja structure rev [ci skip]

Docs guide ja structure views rev [ci skip]

docs/guide/structure-views.md - fix [ci skip]

Added to test for Collapse class

Fixes #7094: Console confirmation must be answered correctly. To return `true`: `y` or `yes`. To return `false`: `n` or `not`. Any other input the question will be asked again

docs/guide/input-forms.md - minor improvements [ci skip]

Docs guide ja input updates [ci skip]

close #7084

Fixes #7074: `yii\data\ArrayDataProvider` did not correctly handle the case `Pagination::pageSize = 0`

Update guides pt-BR [ci skip]