Multiple table names in where condition

Yii 2.0 General Discussions
1

My next query builder


$query->where(["tableNameA.field" => "tableNameB.field"])

generates

...WHERE `tableNameA`.`field` = 'tableNameB.field'

And the desired it should be

...WHERE `tableNameA`.`field` = `tableNameB`.`field`
2

pass it as a string like so

$query->where("tableNameA.field = tableNameB.field")
3

Or as an expression like this

->where(['tableNameA.field' => new \yii\db\Expression('{{%tableNameB}}.[[field]]')])