You'd compress the JSON, and leave the data that you extract from the JSON uncompressed using Generated Columns[1]. That way you can save the original JSON dat

You'd compress the JSON, and leave the data that you extract from the JSON uncompressed using Generated Columns[1]. That way you can save the original JSON data, but still have fast querying, etc. It would look something like this: CREATE TABLE t1( json TEXT, data INT GENERATED ALWAYS AS (json_extract(body, '$.d')) STORED ); If all you need is fast querying you could make `data` a `VIRTUAL` column and set up an index on it. You can read more about this kind of technique here: https://dgl.cx/2020/06/sqlite-json-support https://dgl.cx/2020/06/sqlite-json-support [1]: https://www.sqlite.org/gencol.html https://www.sqlite.org/gencol.html