Int64 type is stored in DuckDB as NULLABLE BIGINT. Calling fetch_df on it converts it to float64 (because it assumes there could be NaNs) which could be confusing for users (for instance weekly covid cases are such a case).
We could either keep it in arrow format, never call fetch_df and let users read it as feather file or convert float64 back to Int64 before returning it to user.
Int64type is stored in DuckDB asNULLABLE BIGINT. Callingfetch_dfon it converts it tofloat64(because it assumes there could be NaNs) which could be confusing for users (for instance weekly covid cases are such a case).We could either keep it in arrow format, never call
fetch_dfand let users read it as feather file or convertfloat64back toInt64before returning it to user.