use SQLite to store JSON à la jsonb in PostgreSQL using virtual generated columns (https://www.sqlite.org/gencol.html)

json-in-sqlite.sql

CREATE TABLE t (
  id integer PRIMARY KEY autoincrement,
  data text
);

INSERT INTO my_objects (data) values('{"foo": "value", "bar": "other value"}'), ('{"foo": "baz", "bar": "qux"}');

ALTER TABLE my_objects ADD COLUMN foo text GENERATED always AS (json_extract(data, $.foo)) virtual;

SELECT * FROM my_objects;
-- id  data                                    foo
-- --  --------------------------------------  -----
-- 1   {"foo": "value", "bar": "other value"}  value
-- 2   {"foo": "baz", "bar": "qux"}            baz