[jira] [Created] (FLINK-17852) FlinkSQL support WITH clause in query statement

[Shang Yuanchun (Jira)]

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)