Hi, I noticed recently that for most lateral views, we do not convert to a CBO plan. I was hoping to make some changes to make this possible.
I was wondering if anyone out there had any thoughts on how to do this. If not, I did have one in mind and wanted to bring it up just to start the conversation before I did any work on it. I was thinking maybe we could have our own RelNode deriving off of LogicalCorrelate. I know we already handle correlated queries and decorrelate them. But in this special case, I think we should not decorrelate the RelNode. We should leave this new LogicalCorrelate node in through the whole optimization process and then put in code to translate the RelNode into the physical plan. Thoughts? Thanks!
