How to make several fields on yii2 distinct without losing the rest?

Question

Yii

Greetings
I'm making a query like this
$model = Files::find()->select(['filename','ext','size'])->distinct()->all();
There is uniqueness in three fields.
Everything is great.
But there are more fields in the Files table. How can I get them?

Answer 1

Yii2 Query builder does not know how to distinct on
There is such a hack : either write the entire SQL query by hand. Model::find()->select('distinct on (a) *')