[Feature]: Visualize JSONB as JSON

[danielepolencic]

Describe the new feature

SQLite 3.45.0 introduced JSONB, a binary encoding of JSON stored as a BLOB.
Unfortunately, inspecting rows in the database with this format is hard because they are not readable.
The "edit database cell" section only supports "Mode: binary", which shows the binary format, not the actual JSON.

The current workaround is to issue a query that converts the blob into actual JSON with SELECT json(jsonb_column) AS actual_json FROM ....

Ideally, there is a new mode to inspect JSONB blobs and display them as actual JSON.

Does this feature exist in another product or project? Please provide a link

No response

Do you have a screenshot? Please add screenshots to help explain your idea.

[mgrojo]

If you don't need to edit the column, you can use a display format.