feat(parser): support emit on window close in parentheses (DBT)

[fuyufjh]

Is your feature request related to a problem? Please describe.

Currently we parse emit on window close as part of the create statement rather than select . As a result, queries like create materialized view ... as ( ... emit on window close ) can't be accepted because the parentheses explicitly include emit on window close as part of select.

The parentheses were added by dbt to wrap any materialized view query. Thus, this problem affect all DBT users.

Describe the solution you'd like

Is it possible to modify the parser to work around this?

Describe alternatives you've considered

No response

Additional context

No response

[fuyufjh]

@chenzl25 Is it possible to fix this by modifying the DBT risingwave plugin?

[chenzl25]

Yes. I had fixed this problem in DBT. risingwavelabs/dbt-risingwave#45