Native Dynamic JSON Support in Python's sqlite3

[DaFi-1]

Description

Add a standardized way for the sqlite3 module in Python to store and retrieve dict and list objects directly as JSON in SQLite, without requiring manual use of json.dumps() and json.loads().

Idea

• Insert dict/list → automatically stored as JSON
• Read JSON column → automatically returned as dict/list
• Basic JSON query support (if JSON1 extension is available)

Is it viable?

Yes.

Will it break current architecture?

No, if implemented as an optional adapter/converter.

Reality

Unlikely to be added to the core because sqlite3 is intentionally minimal.
More likely to exist as an external extension or library.

[picnixz]

Unlikely to be added to the core because sqlite3 is intentionally minimal.
More likely to exist as an external extension or library.

This does not warrant an issue then if you are aware of this. You can share your idea on discuss.python.org though.

[picnixz]

Note: I believe that sqlite3 has a converter and adapter mechanism so you might not necessarily need too much