SQLite document

sample.sql

-- https://www.sqlite.org/json1.html

CREATE TABLE stat
(
    id          INTEGER   NOT NULL PRIMARY KEY AUTOINCREMENT,
    started_at  TIMESTAMP NOT NULL DEFAULT current_timestamp,
    finished_at TIMESTAMP NOT NULL DEFAULT current_timestamp,
    meta        JSON      NOT NULL DEFAULT '{}' -- JSON!
);
CREATE INDEX stat_meta_project ON stat (meta ->> 'project');

INSERT INTO stat(meta)
VALUES ('{
  "project": "hello",
  "workspace": "default",
  "method": "POST"
}'),
       ('{
         "project": "help",
         "workspace": "default",
         "method": "POST"
       }');


SELECT *
FROM stat;

SELECT *
FROM stat
WHERE meta ->> 'project' = 'hello';

EXPLAIN QUERY PLAN
SELECT *
FROM stat
WHERE meta ->> 'project' = 'hello';