Is your feature request related to a problem or challenge?

It was decided that further development of array functions will be carried out according to the following concept: #6855.
According to the concept, any changes may be subject to rational criticism, so some aspects may change.
It should be noted that this list is incomplete and will be updated in the future.
The ticket contains many tickets. Each ticket is divided into respective categories:

List of features

A complete list of features, the implementation of which is desirable from the point of view of this concept 🎯:

Cleanups

• Lots of code duplication in array_functions (array_replace_all, array_replace_n, array_replace, etc) #7988

Managing array elements:

By index:

• array_element Implement array_element function #6974
• array_slice Implement array_slice function #6975

By borders:

• array_pop_front Implement array_pop_front function #6996
• array_pop_back Implement array_pop_back function #6997

Working with Array Characteristics

Dimension

• flatten Implement flatten function #6995

Set language:

Basic operations on sets:

• Implement array_union function #6981
• Implement array_intersect function #6978
• Implement array_except function #6979

Checking if elements belong:

• array_has_all Implement array_has_all function #6973
• array_has_any Implement array_has_any function #6976
• array_has Implement array_has function #6977

Form an array:

• array_repeat Implement array_repeat function #7197
• array_resize Implement array_resize function #7194

Array aggregate functions:

• Implement array_aggregate function #7213
• Implement array aggregate functions #7214

Array operators:

• Support all array operators to work with columns #7119

Handling NULL and empty array:

• Improve handling of NULL and empty array for array functions. #7143
• All array functions should represent NULL as an element #7142
• make_array should support pure null array #7144
• make_array null handling with nested version #7136
• Implement empty function #7290

Refactoring:

• Refactoring the array ecosystem #7279
• Improve array data types #7288

Other functions:

• Implement array_distinct function #7289
• Support udf range #8028

Bugs

• array_agg with pyarrow errors with ArrowInvalid: Schema at index 0 was different #8032

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response