Explode a JSON column to a new table is SQLite

JSONExplode.sql

-- Create a table that will contain all the JSON object keys
CREATE TABLE KEYS (attrname STRING, expr STRING);
INSERT INTO KEYS
       SELECT DISTINCT(e.key), e.fullkey AS key
         FROM json_each(log.line) e, log;

-- Generate the CREATE TABLE with all the JSON object keys
.once eval.sql
SELECT 'CREATE TABLE exploded (k_' || group_concat(attrname,' TEXT, k_') || ' TEXT);'
  FROM (SELECT attrname FROM keys);

-- Execute the CREATE TABLE
.read eval.sql

-- Generate the INSERT INTO statement to populate the exploded table
.once eval.sql
SELECT 'INSERT INTO exploded SELECT ' || GROUP_CONCAT(e, ', ') || ' FROM log;'
  FROM (SELECT 'json_extract(line, ''' || expr || ''')' AS e FROM keys);

-- execute the INSERT INTO
.read eval.sql