v.23.2Improvement

Support for IN Clause with Parameters in Parameterized Views

Support for IN clause with parameter in parameterized views. #46583 (SmitaRKulkarni).
Support for the IN clause with parameters in parameterized views.

Why it matters

This feature enables users to use the IN clause with parameters within parameterized views, allowing more flexible and dynamic querying capabilities. It addresses the limitation where IN clauses could not be parameterized in views, improving query expressiveness and usability.

How to use it

To use this feature, define parameterized views that include the IN clause with parameters. Pass the desired parameter values at query time to filter the view accordingly.