[Bug]: UNNEST ARRAY with a nested ROW (described below)

### What happened?

In Beam SQL shell (tested with calcite, DirectRunner, DataFlow, v2.47.0 and latest main on linux):
```
CREATE EXTERNAL TABLE test_tmp(
`ref` VARCHAR,
`commits` ARRAY
>>
)
TYPE text
LOCATION 'tests/array_with_nested_rows_limitation.jsonl'
TBLPROPERTIES '{"format":"json", "deadLetterFile":"tests/dead"}';
SELECT
test_tmp.`ref` AS branch_name,
commit_item.`id` AS commit_hash,
commit_item.`author`.`name` AS author_name
FROM test_tmp
CROSS JOIN UNNEST(test_tmp.commits) AS commit_item;
```
gives
```
Row expected 4 fields (Field{name=ref, description=, type=STRING, options={{}}}, Field{name=commits, description=, type=ARRAY> NOT NULL>, options={{}}}, Field{name=id, description=, type=STRING, options={{}}}, Field{name=author, description=, type=ROW, options={{}}}). initialized with 5 fields.
```
Which essentially leaves no way to explode all elements of an array through SQL. Accessing a single element works as expected.
Also related issue - when doing `SELECT *` from a table that contains at least one nested row - a very similar exception is thrown.

### Issue Priority

Priority: 1 (data loss / total loss of function)

### Issue Components

- [ ] Component: Python SDK
- [X] Component: Java SDK
- [ ] Component: Go SDK
- [ ] Component: Typescript SDK
- [ ] Component: IO connector
- [ ] Component: Beam examples
- [ ] Component: Beam playground
- [ ] Component: Beam katas
- [ ] Component: Website
- [ ] Component: Spark Runner
- [ ] Component: Flink Runner
- [ ] Component: Samza Runner
- [ ] Component: Twister2 Runner
- [ ] Component: Hazelcast Jet Runner
- [ ] Component: Google Cloud Dataflow Runner