Table-Names can now also be arrays
Pre-release
Pre-release
Now you can do this:
$select
->field('a.a')
->field('b.b')
->from('a', [['a' => 1, 'b' => 3], ['a' => 2, 'b' => 2], ['a' => 3, 'b' => 1]])
->joinInner('b', [['a' => 1, 'b' => 3], ['a' => 2, 'b' => 2], ['a' => 3, 'b' => 1]])
Which will result in this:
SELECT
a.a,
b.b
FROM
(SELECT '1' AS `a`, '3' AS `b`
UNION
SELECT '2' AS `a`, '2' AS `b`
UNION
SELECT '3' AS `a`, '1' AS `b`) a
INNER JOIN
(SELECT '1' AS `a`, '3' AS `b`
UNION
SELECT '2' AS `a`, '2' AS `b`
UNION
SELECT '3' AS `a`, '1' AS `b`) b