findBySql() публичный статический Метод

Note that because the SQL statement is already specified, calling additional query modification methods (such as where(), order()) on the created ActiveQuery instance will have no effect. However, calling with(), asArray() or indexBy() is still fine. Below is an example: php $customers = Customer::findBySql('SELECT * FROM customer')->all();
public static findBySql ( string $sql, array $params = [] ) : ActiveQuery
$sql string the SQL statement to be executed
$params array parameters to be bound to the SQL statement during execution.
Результат ActiveQuery the newly created [[ActiveQuery]] instance
Документация по классу ActiveRecord
Пример #1
0
 public static function execSql($sql, $obj = false)
 {
     return $obj ? parent::findBySql($sql)->all() : parent::findBySql($sql)->asArray()->all();
 }