Implement getArray() in BigQueryResultImpl

[o-shevchenko]

Add support for array data types in BigQueryResultImpl.

Currently, there isn't a way to read repeated fields in BigQuery.

getArray method is not implemented and throws: 'java.sql.SQLFeatureNotSupportedException' exception.

[PhongChuong]

@o-shevchenko , thanks for the report. I might not get to this item for another few weeks. Just so I understand, is there any specific timeline that you need t hit? We'll try to accommodate.

[o-shevchenko]

Thanks for the answer @PhongChuong!
For now, we have a workaround with a manual transformation of arrays to ByteArray and back, but we want to simplify this logic. We are not blocked, so I don't want to rush you. We are looking for comprehensive support for BQ data types since we need to be able to read any BQ table of any type.
Another problem is reading and writing back STRUCT fields. It's quite problematic, especially for nested types.

[PhongChuong]

@o-shevchenko ,
Thanks for the context. I'll add support for arrays soon.

Regarding structs, the java.sql.ResultSet interface does not seem directly support struct fields. I'll take a closer look and see how to best support this.