Why does Yii2 pull all data from the database when calling the batch method?

Question

Yii

In general, the thing is.

foreach(Item::find()->batch(100) as $batch) {

}

Nothing complicated. But there are n million rows in the database. When executing the code, a request flies to the database: Here comes the w... The request is executed in the yii2\db\Command:901 line:
SELECT * FROM items
$this->pdoStatement->execute();

Answer 1

Are you sure you want batch and not limit() and offset() ?

Answer 2

Issue not resolved
https://github.com/yiisoft/yii2/issues/8420