Allow creating views with properties

[Praveen2112]

Background and Motivation

Currently Tables and Materialized Views has an option to provide properties as a part of its definition, we would like to extend the same to Views as well. The proposed syntax would be

CREATE VIEW view_name WITH (property_key = 'property_value') AS SELECT ...

Implementation details

On the implementation side - we have two options

1. Maintain the view properties as a part of ConnectorViewDefinition - like ConnectorTableMetadata
2. Handle a different set of APIs specific like we do for MaterializedViews like getMaterializedViewProperties.

Which option could we consider ?

Tasks

Beta Give feedback

1. Add support for creating views in Trino Grammar.
2. Add extra_properties for Hive views like Add extra_properties to hive table properties #17172
3. Expose the properties via System table
4. Add support to update the view properties
5. Add docs for creating views with properties and document creating extra_properties

[Praveen2112]

@martint Can you please confirm the proposed syntax.

cc: @findepi / @findinpath On how could we extend them to other connectors like iceberg or delta lake