FILTER() in windowing function

[devprofile98]

Is your feature request related to a problem? Please describe.

The absence of the FILTER clause in window functions makes certain queries unnecessarily cumbersome. While alternative methods (e.g., CASE statements, subqueries, or CTEs) can achieve the same results, these workarounds often lead to more complex, longer, and harder-to-maintain SQL code. For example, queries that could be simplified with SUM(column) FILTER (WHERE ...) require multiple steps or nested logic, increasing the likelihood of errors and reducing readability.

Describe the solution you'd like

No response

Describe alternatives you've considered

using CTE's or subqueries or CASE

Additional context

No response