alamb commented on issue #10048: URL: https://github.com/apache/datafusion/issues/10048#issuecomment-2226298681
> > I am not familar enough with lateral joins to be sure without some more research > > The `LATERAL` join syntax from Postges[1](#user-content-fn-1-34707c1f2caf3760a3ce090ed62c61c5) (which is adopted by DuckDB) effectively is a syntactic counterpart of the dependent join from the Neumann and Kemper paper cited above. I think the first step is fixing the `SqlToRel` to make earlier `FROM` bindings available to the `LATERAL` input. > > ## Footnotes > 1. https://www.postgresql.org/docs/16/sql-select.html [↩](#user-content-fnref-1-34707c1f2caf3760a3ce090ed62c61c5) Thanks -- I have had that paper on my reading list for a while. I think it is time to bump it to the top -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org