@Cory Grinstead if you would like to take on some of the rewriter rules, you could start with uncorrelated subqueries. It should be a good first step for supporting subqueries! If you have other work feel free to prioritize that though, I was going to get to this right after I have a PR out for cross joins