SQL
Aggregate Window Functions
All [aggregate functions](#docs:sql:functions:aggregates) can be used in a windowing context, including the optional [`FILTER` clause](#docs:sql:query_syntax:filter).
The `first` and `last` aggregate functions are shadowed by the respective general-purpose window functions, with the minor consequence that the `FILTER` clause is not available for these but `IGNORE NULLS` is.