Is your feature request related to a problem or challenge?
With the support of ordering sensitive aggregation in #6332. We can add new ordering sensitive aggregators to the datafusion.
Add support for FIRST_VALUE, LAST_VALUE aggregation functions. Currently, we only support these functions in window clauses.
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response