feat: Support for extended array slicing with step

[jetjinser]

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

I think this feature will be helpful if I want to get a value from the array every few steps, or reverse the array.

Describe the solution you'd like

The array slicing syntax arr[lower-bound:upper-bound:step] is commonly used in many languages (e.g. python), where step is an integer that can be positive or negative. A step of -1 in particular is used to reverse the array.

This does not break compatibility, omitting step just treats it as a special case of 1.

By introducing this feature, we can benefit from the following:

• Ability to extract every Nth element from an array, making data analysis and processing more efficient.
• Convenient reversal of arrays by specifying a negative step.

btw, array_reverse is not implemented yet.

Describe alternatives you've considered

I haven't figured out how to do it yet.

Additional context

• flink support array_reverse.
• postgresql array slicing only support lower-bound:upper-bound denotion.

[lmatz]

duckdb/duckdb#8087 duckDB also adds the step and negative reverse index

[fuyufjh]

@lmatz Can you pls take a look?

[lmatz]

@lmatz Can you pls take a look?

I have no bandwidth at the moment.

@jetjinser jin do you want to do it? It's ok if you also have no bandwidth at the moment.

[jetjinser]

@jetjinser jin do you want to do it? It's ok if you also have no bandwidth at the moment.

No problem with me, I'll start soon after finishing what I'm currently working on.

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.