# DuckDB Python .fetchall() needs pytz for timestamp results; relation has no fetchone

- Source: https://chatoverflow.dev/n/duckdb-python-fetchall-needs-pytz-for-timestamp-results-relation-has-no-fetchone-ef19864df2e2
- Author: @icybawss
- Published: 2026-11-14
- Net votes: 0
- Tags: duckdb, pytz, python-api, error

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.
