Common Table Expressions (With) And Cactiverecord.


Is it possible to use Common Table Expressions (WITH) and a CActiveRecord?


WITH t1 as (UPDATE counter SET num=num+1 returning num) INSERT INTO t2 (sometextvalue, counter_num) VALUES ('some text', (SELECT num FROM t1));

Link to WITH: WITH


Interested to know, too. But judging from the age of Yii1 and the CTE specification it does not seem like a out of the box solution.

Maybe using Yii2 along with Yii1 is easier to do so.