James Starr

@Zabetak, This PR is focused on handling left joins with correlated queries in ON clauses. Joins with correlated queries are rewritten too as join with the right side contain filter...

@zabetak, do you have any further feed back?

@zabetak I pulled in master, create separate ticket and cleaned up the code, and rewrote the pull request comment. Let me know if any further changes are needed.

@zabetak, Could you please merge this.

@Zabetak, I really do not want this going to the graveyard of calcite pull requests.

This branch is ready for review. Could some one review it please.

So this currently works for subqueries that do not rewrite the black board root node.

Could some one help me understand why the Avatica master check is failing?

> @jamesstarr , what is the status of this PR? @jacques-n left some feedback but I think the PR was not synced to the main dev branch, it's not clear...

> What is the status on this PR? Was it ready to be merged? cc @zabetak I've been trying to follow the trail of relevant JIRA tickets Never mind, I...