Implement array_pop_back function

[izveigor]

Is your feature request related to a problem or challenge?

Summary

Characteristic	Description
Function name:	array_pop_back
Aliases:	list_pop_back
Original function?:	No
Function Description:	ClickHouse: Removes the last item from the array. DuckDB: Returns the list without the last element.
Sources:	Concept DuckDB ClickHouse

Examples:

D select array_pop_back([1, 2, 3, 4]);
┌─────────────────────────────────────────────┐
│ array_pop_back(main.list_value(1, 2, 3, 4)) │
│                   int32[]                   │
├─────────────────────────────────────────────┤
│ [1, 2, 3]                                   │
└─────────────────────────────────────────────┘
D select array_pop_back([[1, 2], [3, 4], [4, 2]]);
┌──────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ array_pop_back(main.list_value(main.list_value(1, 2), main.list_value(3, 4), main.list_value(4, 2))) │
│                                              int32[][]                                               │
├──────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ [[1, 2], [3, 4]]                                                                                     │
└──────────────────────────────────────────────────────────────────────────────────────────────────────┘

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[tanruixiang]

Hi, I'm interested in this issue, can I give it a try?

[izveigor]

Hello, @tanruixiang!
Yes, you can give it. It seems to me that the implementation is to use array_slice function, like array_slice(array, 0, len(array)-1).

[tanruixiang]

Hello, @tanruixiang! Yes, you can give it. It seems to me that the implementation is to use array_slice function, like array_slice(array, 0, len(array)-1).

Thank you very much for your advice.❤️

[jayzhan211]

@tanruixiang Also ping me when you are ready for review.

[tanruixiang]

@izveigor @jayzhan211 I apologize for the longer delay in this issue due to some other things. It is now ready for REVIEW.