4 ms·
Another thing, this makes things harder to reverse. Some engines have join-order-dependent performance, so there are instances where you would want to write `
by ridaj 5y ago
Another thing, this makes things harder to reverse.
Some engines have join-order-dependent performance, so there are instances where you would want to write
```
FROM orders
LEFT JOIN customers USING (customer_id)
```
and others where you'd want to write
```
FROM customers
RIGHT JOIN orders USING (customer_id)
```
Swapping join order with current syntax is relatively easy since references in the same FROM clause are interchangeable. But in this proposal, the reference to the joined table isn't written out, so it would be pretty complicated to reverse join order.