Allow right side of join to be generic query expression

[joshua-spacetime]

Right now the right side of a join is a table scan that is fully materialized before executing the join. Instead it should be a query expression to allow for other operations below, or before, the join.