SQLite 3.9.0, released in Oct 2015, introduced the
json1 extension
that provides functions to manage JSON content stored in an SQLite
database. The extension source code is included in the SQLite source
amalgamation and is enabled by the -DSQLITE_ENABLE_JSON1 option.

The following assumes that the json1 functionality is available. As sample
data, I use the stocks data set from
jsonstudio.com. Here's what the
wrapped first line of the JSON data file looks like partially: