Window script function enhancements

The syntax, functionality, and documentation of window functions have been enhanced to improve usability and flexibility. Window functions are commonly used for analytics and ML data preparation scenarios that require aggregations across different partitions without losing the grain of the input data.

Enhancements include:

• Added support for performing aggregations on data ordered by a specified sorting expression, enabling sorted sliding windows instead of relying on the default load order.

• Clarified documentation and improved behavior when handling optional parameters

• Fixed an issue where the WRank function returned incorrect values when nested inside another expression.

Window – Script function