Add PostgreSQL-style cast operator with array and tuple indexing support

Why it matters

This feature enables more flexible and concise type casting on complex expressions involving arrays and tuples, allowing users to write clearer and more expressive queries when working with nested data structures.

How to use it

Users can apply the PostgreSQL-style cast operator by appending ::Type to expressions that include [] or . indexing, for example:

SELECT (my_array[1])::UInt32, (my_tuple.element)::String FROM my_table;