slack_migrate.sql

INSTALL json;
LOAD json;
INSTALL sqlite;
LOAD sqlite;

ATTACH 'messages.db' AS sqlite_db (TYPE SQLITE);
CREATE TABLE sqlite_db.messages  (name VARCHAR, text VARCHAR, ts VARCHAR, channel VARCHAR);

INSERT INTO sqlite_db.messages (SELECT user_profile.real_name as name, 
                               text, 
                               ts, 
                               regexp_extract(filename, '^slack-export/(.*)/', 1) as channel
                               FROM read_json_auto('slack-export/**/*.json',
                                                    filename = true));