Outputting data from the first database table that is not in another, related table?

Question

Yii

There is a query to the database
which, from one table, selects values ​​that are not in another table:

SELECT * FROM parameters
WHERE NOT EXISTS
(
    SELECT * FROM userparam
    WHERE userparam.parameters_id = parameters.id
          AND userparam.user_id = 42
);

how to write this request through yii2 methods??

Answer 1

Yes, and write, why bind QueryBuilder here if Connection has a createCommand ($ sql) method, which is just right for you.
https://www.yiiframework.com/doc/api/2.0/yii-db-command