Feature Request: Return JSON duckdb fields as JSON to Python via fetchone() or fetchall() rather than as strings. #195
JonathanSFalk
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have a database with several JSON fields. When I result=conn.query("SELECT json_field FROM db").fetchall() I get strings in Python which I then need to convert back to get the json object I want to work with result_json = json.loads(result). Is there some limitation that stops fetchall)_ or fetchone() from keeping the result as JSON? I understand (or accept) that this won't work in .df()
Beta Was this translation helpful? Give feedback.
All reactions