Testing json generated columns

json_generated_columns.sql

DROP TABLE activities;

CREATE TABLE activities (
    id INTEGER NOT NULL PRIMARY KEY,
    activity TEXT NOT NULL,
    type TEXT GENERATED ALWAYS AS (json_extract(activity, '$.type')) STORED,
    name text GENERATED ALWAYS AS (json_extract(activity, '$.name')) STORED
);

INSERT INTO
    activities (activity)
VALUES
    (
        '{
  "type": "Foo",
  "name": "Bar",
  "quantity": 1
}'
    );

INSERT INTO
    activities (activity)
VALUES
    (
        '{
  "type": "Hello",
  "name": "World",
  "quantity": 2
}'
    );

SELECT
    type,
    name,
    json_extract(activity, '$.quantity') AS quantity
FROM
    activities;