support VALUES as a table we can join on

[phderome]

SELECT a.name, v.address FROM (VALUES('101 Main St City USA', 'foo', 'bar'), ('24 Sussex Drive Ottawa Canada', 'foo2', 'bar2')) vals(address, foo, bar) CROSS JOIN A

with any kinds of joins being supported as usual. So (VALUES) looks like a subquery (SELECT ...).

[jdegoes]

I think this is already supported via the literal read, but we can add a test too.