It should be possible to set a table alias on indexBy

[brandonkelly]

yii\db\Query::$indexBy should support being set to an aliased column name, for example:

$query->indexBy('users.username');

Oddly, there already is half-baked support for this in column(), in that the FROM table alias is only prepended to the DB query if indexBy doesn’t already contain a .:

yii2/framework/db/Query.php

Line 311 in bbbcc9e

if (strpos($this->indexBy, '.') === false && count($tables = $this->getTablesUsedInFrom()) > 0) {

To complete the feature, the table alias just needs to be stripped out on this line, if set:

yii2/framework/db/Query.php

Line 325 in bbbcc9e

$results[$row[$this->indexBy]] = $value;

[brandonkelly]

Thanks @samdark!