Allow COMMENT in CREATE VIEW for all VIEW kinds

Why it matters

This feature enables users to attach descriptive comments to views at creation time, improving schema documentation and maintainability by allowing metadata to be stored directly with the views.

How to use it

When creating a view with CREATE VIEW, include the COMMENT clause to add a description. For example:

CREATE VIEW view_name COMMENT 'This is a descriptive comment' AS SELECT ...