How to pass $query date to provider?

Question

Yii

I pass the date to the provider the Query object as it is written in the documentation, it says to me that the type requires an instance of the Query class, but how do I pass the class instance if, after creating the Query object, I create an array from the result of the sql query?

$query = (new Query())
                ->select($columns)
                ->from([BaseMaterial::tableName(), $table_name])
                ->all();
            
            $dataProvider = new ActiveDataProvider([
                'query' => $query
            ]);

Answer 1

You are not passing query.
It would be correct like this:

$query = (new Query())
                ->select($columns)
                ->from([BaseMaterial::tableName(), $table_name]);
            
            $dataProvider = new ActiveDataProvider([
                'query' => $query
            ]);