Consider supporting correlated subqueries without equi-join predicates

The Nested loop join supports a variety of join modes and we could rewrite more subqueries into nested loop joins. The downside is that the performance could be very poor in many cases