Support for Parameterized Views in Iceberg

[WasimIsmail]

Feature Request / Improvement

Issue Description:
Overview
Iceberg currently supports regular views, but it lacks support for parameterized views, which would allow users to pass arguments dynamically when querying views.

Adding parameterized views will enable better query reusability and flexibility in Iceberg-supported engines like Trino, Spark, and Flink.

CREATE VIEW iceberg_catalog.my_schema.parameterized_view AS
SELECT a, b FROM my_schema.sample_table WHERE month_end = '{param_date:String}';

SELECT * FROM iceberg_catalog.my_schema.parameterized_view(param_date='2024-05-01');

Proposed Changes in Iceberg
-Modify ViewMetadata to support parameter definitions in ViewMetadata.json
-Enhance ViewCatalog to resolve parameters at query execution
-Introduce parameter validation to ensure correct types
-Modify Iceberg's REST API to support parameterized views
Use Case Example
Instead of manually filtering views, users can pass parameters dynamically, improving query efficiency:

SELECT * FROM my_schema.sales_report_view(year='2023', region='US');

As an example - Clickhouse supports parameterized views: https://clickhouse.com/docs/knowledgebase/how_to_use_parametrised_views

Query engine

Trino

Willingness to contribute

• I can contribute this improvement/feature independently
• I would be willing to contribute this improvement/feature with guidance from the Iceberg community
• I cannot contribute this improvement/feature at this time

[ajantha-bhat]

@WasimIsmail: Have you checked the proposal about SQL UDFs?
#10432

I believe SQL Udfs will also cover the usecase of parametrized views.