Testing json generated columns

json_generated_columns.sql

DROP TABLE activities;

CREATE TABLE activities (
    id serial NOT NULL PRIMARY KEY,
    activity json NOT NULL,
    type text GENERATED ALWAYS AS (activity ->> 'type') STORED,
    name text GENERATED ALWAYS AS (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,
    activity ->> 'quantity' AS quantity
FROM
    activities;