Lordworms opened a new issue, #9354: URL: https://github.com/apache/arrow-datafusion/issues/9354
### Is your feature request related to a problem or challenge? When I was doing #9323 , I found that duckDB supports this syntax <img width="1034" alt="image" src="https://github.com/apache/arrow-datafusion/assets/48054792/03a885a9-dfe5-441b-96f4-cbab4b5d2523";> which does not implemented in datafusion <img width="975" alt="image" src="https://github.com/apache/arrow-datafusion/assets/48054792/6b5ed843-1932-4c85-a95a-36f73b7d83d5";> I think we should support such structures ### Describe the solution you'd like I have not really thought about it. A rough solution for this should be adding a new table schema in the default schema and when we emit the subquery, we add a new entry to the default schema and then do the following steps? I think we should deduce whether an expression could be evaluated as a temp table or not(In SQLparser or not?) and then add schema to the default schema book. This might include changing SQLparser and lots of existing logics ### Describe alternatives you've considered _No response_ ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
