Deprecate builtin first/last aggregate function and use UDAF

[jayzhan211]

Which issue does this PR close?

Part of #8708 Closes #9957 #10062

Rationale for this change

What changes are included in this PR?

Additionally, check the signature for UDAF, and extend it to support List. Window Aggregate function also works with UDAF surprisingly without any change about the window function

Are these changes tested?

Are there any user-facing changes?

[alamb]

I plan to review this tomorrow (sorry I am out this week for vacation so I have more limited bandwidth)

[jayzhan211]

I think reverse_expr should be included before deprecate builtint first/last, so convert to draft.