[CALCITE-1490] Allow table functions without explicit TABLE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.37.0
• Labels: dialect
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 14/Nov/16 19:38
• Updated: 08/Feb/24 19:00
• Resolved: 08/Feb/24 19:00

Description

Currently, per the SQL standard, if you want to use a table function, you need to use the TABLE keyword, like this:

SELECT * FROM (TABLE myFun(1, 'a'))

In Microsoft SQL Server you can omit the TABLE:

SELECT * FROM myFun(1, 'a')

This makes the SQL grammar more complicated (and possibly ambiguous, I haven't checked), and makes name-resolution during validation more complicated (tables and table-functions would now occupy the same namespace).

If we supported this, it would be via a new method in SqlConformance. It would be enabled in the SQL Server conformance, disabled otherwise.

Issue Links

• duplicates: CALCITE-6254 Support table function calls in FROM clause without TABLE() wrapper
• is duplicated by: CALCITE-4396 Allows table valued functions of FROM and JOIN context without TABLE clause
• relates to: CALCITE-3272 TUMBLE Table-valued Function
• relates to: CALCITE-1472 Support CROSS/OUTER APPLY syntax