Parameterized Functions Supported in APPLY Column Transformer

Why it matters

This feature allows users to apply more flexible and dynamic transformations on columns by using parameterized functions inside the APPLY transformer. It enhances the capability of column-wise operations, enabling complex function calls with parameters to be executed directly during data transformations.

How to use it

Use the APPLY column transformer and pass parameterized functions as arguments. For example:

SELECT <code>APPLY</code>(column, parameterized_function(params)) FROM table

This new capability lets you invoke functions that require parameters within APPLY, just like standard function calls.