Is your feature request related to a problem?

For queries like

select max(arr[1][1])
from tab;

we don't need to do a full decoding of the arr array column. Instead, we should decode only the first array element.

We should also consider pushing down other array access operations like slices.

Describe the solution you'd like.

No response

Describe alternatives you've considered.

No response

Full Name:

Andrei Pechkurov

Affiliation:

QuestDB

Additional context

No response