General ticket for Array/List data type

### Is your feature request related to a problem or challenge?

This is a common ticket for all other tickets.
The ticket was created for the next purposes:
- Track the progress of implementing array functions
- Group issues by category
- Helps developers better understand problem selection

### Describe the solution you'd like

# Tickets:
## Array creating:
- https://github.com/apache/arrow-datafusion/issues/6808
- https://github.com/apache/arrow-datafusion/issues/6556
- https://github.com/apache/arrow-datafusion/issues/6561
- https://github.com/apache/arrow-datafusion/issues/6887
- https://github.com/apache/arrow-datafusion/issues/6993

## Array functions:
- https://github.com/apache/arrow-datafusion/issues/6779
- https://github.com/apache/arrow-datafusion/issues/6560
- https://github.com/apache/arrow-datafusion/issues/6555
- https://github.com/apache/arrow-datafusion/issues/6804
- https://github.com/apache/arrow-datafusion/issues/6557
- https://github.com/apache/arrow-datafusion/issues/6119
- https://github.com/apache/arrow-datafusion/issues/6075
- https://github.com/apache/arrow-datafusion/issues/6849
- https://github.com/apache/arrow-datafusion/issues/6972
- https://github.com/apache/arrow-datafusion/issues/6992

## Array operators:
- https://github.com/apache/arrow-datafusion/issues/6806
- https://github.com/apache/arrow-datafusion/issues/6603
- https://github.com/apache/arrow-datafusion/issues/6884

## Cast:
- https://github.com/apache/arrow-datafusion/issues/6558

## Concept:
- https://github.com/apache/arrow-datafusion/issues/6980
- https://github.com/apache/arrow-datafusion/issues/6973
- https://github.com/apache/arrow-datafusion/issues/6974
- https://github.com/apache/arrow-datafusion/issues/6975
- https://github.com/apache/arrow-datafusion/issues/6976
- https://github.com/apache/arrow-datafusion/issues/6977
- https://github.com/apache/arrow-datafusion/issues/6978
- https://github.com/apache/arrow-datafusion/issues/6979
- https://github.com/apache/arrow-datafusion/issues/6981

## Other:
- https://github.com/apache/arrow-datafusion/issues/6985
- https://github.com/apache/arrow-datafusion/issues/6602
- https://github.com/apache/arrow-datafusion/issues/6559
- https://github.com/apache/arrow-datafusion/issues/6961
- https://github.com/apache/arrow-datafusion/issues/7146
- https://github.com/apache/arrow-datafusion/issues/7147

# Discussions:
- https://github.com/apache/arrow-datafusion/discussions/6855

### Describe alternatives you've considered

### Additional context
- https://github.com/apache/arrow-datafusion/issues/6980
- https://github.com/apache/arrow-datafusion/issues/2326
- https://github.com/apache/arrow-datafusion/issues/6780

This is an umbrella tracker rather than a standalone implementation task. Review the linked array-creation, function, operator, cast, concept, and other tickets, along with discussion 6855; progress is complete when the related tickets are appropriately grouped and tracked here.

Written by the indexing model from the issue text.