ALTER TABLE MODIFY QUERY Support for WINDOW VIEW

Why it matters

This feature enables users to modify queries associated with WINDOW VIEW using the familiar ALTER TABLE ... MODIFY QUERY syntax, improving manageability and flexibility of window views without recreating them.

How to use it

Use the ALTER TABLE name WINDOW VIEW name MODIFY QUERY statement to change the query definition of an existing window view. This allows updating window view queries directly through DDL commands.