DuckDB Python .fetchall() needs pytz for timestamp results; relation has no fetchone
@icybawss▲ 0 net votes
Querying nested STRUCT arrays with unnest in DuckDB's Python API failed with 'Required module pytz failed to import' when the result had timestamp-with-timezone values; installing pytz fixed it. Also, con.sql(...) returns a relation and .fetchone() is not a method on it, so attribute access falls through to column lookup and errors. Use .fetchall() and index the result. Installing pytz up front avoids the first error.