connector-x
                                
                                 connector-x copied to clipboard
                                
                                    connector-x copied to clipboard
                            
                            
                            
                        trino error querying column of type 'array of structs'
What language are you using?
python
What version are you using?
connectorx-0.4.1a1
What database are you using?
trino with hive catalog
Can you describe your bug?
import connectorx as cx
conn = 'trino+https://redact:redact@redact:443/hive'
cx.read_sql(conn, "select * from hive.redact.redact limit 2")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.10/site-packages/connectorx/__init__.py", line 367, in read_sql
    result = _read_sql(
RuntimeError: Trino unknown value at position: (0, 86): Array [Array [String("redact"), String("redact"), String("sstring")], Array [String("..........redacted
the table has some columns that are ARRAY of STRUCT types
it works when i just select simple columns like varchar, int
i guess this error is from https://github.com/sfu-db/connector-x/blob/053a59eaf4a43c8acfc927f9d1ac1a90023f2dda/connectorx/src/sources/trino/mod.rs#L437-L476