$query = User::find()->where(['LIKE', 'name', 'ad%', false]);
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
// SELECT * FROM `user` WHERE `name` LIKE 'ad%'
$query = User::find()->where(['LIKE', 'name', 'ad%', false]);
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
// SELECT * FROM `user` WHERE `name` LIKE 'ad%'