sam lin created FLINK-17852:
-------------------------------
Summary: FlinkSQL support WITH clause in query statement
Key: FLINK-17852
URL: https://issues.apache.org/jira/browse/FLINK-17852
Project: Flink
Issue Type: New Feature
Components: Table SQL / API
Reporter: sam lin
Many modern SQL language support WITH clause in query statement. e.g.
```
WITH myName AS (
select * from table where ...
)
select column1 from myName
```
e.g. In BeamSQL supports
`{{query_statement:
[ WITH with_query_name AS ( query_expr ) [, ...] ]
query_expr`.
}}[https://beam.apache.org/documentation/dsls/sql/calcite/query-syntax/]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
