Hi, org.apache.calcite.test.JdbcTest#testUnnestArrayColumn says "Per SQL std, UNNEST is implicitly LATERAL"
Currently lateral table functions are cumbersome to write: select * from main m, lateral (select ... from table(tableFunction(m.col))).. I know table(...) in Oracle is implicitly lateral since Oracle 9i (since ~2003?) even though "lateral" support was first officially published only in Oracle 12.1.0.1. I wonder if we can make "table(...)" implicitly lateral as well, so the syntax will become select * from main m, table(tableFunction(m.col)) ... PS. I've no idea how to check if that matches the spec or not. Vladimir
