Closed
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Implement subqueries like
SELECT f.x FROM foo as f WHERE f.x IN (select a from bar) as sq;
Describe the solution you'd like
It would be nice to use a SEMI join for this, something like
Projection(f.x, sq.a)
--> Join(Semi f.x = sq.a)
--> TableScan(foo)
--> Projection(a) <--- Here is where the "subquery"'s LogicalPlan is attached
--> TableScan(bar)
Describe alternatives you've considered
Additional context