Join with alias

[trendfischer]

I tried to find a way to add a "JOIN" with an alias for the table. I only found the following way to implement this:

    $query->join(new Expression('`location` AS `work`'), 'work.id', '=', 'users.work_location_id');
    $query->join(new Expression('`location` AS `home`'), 'home.id', '=', 'users.home_location_id');

Using an expression does not seem to be the intended way for this, especially as quoting is not based on the given dialect.

Would it be possible to implement a solution like this:

    $query->join(['work' => 'location'], 'work.id', '=', 'users.work_location_id');

or like the workaround I am using now (the class Alias implements the ExpressionInterface for this):

    use Dialect\MySQL\Alias;
    //...
    $query->join(new Alias('location', 'home'), 'home.id', '=', 'users.home_location_id');

Or is there an implementation, which I missed?