Personal Knowledge Graphs, Semantic Knowledge, Data Design, Relational Databases, AI.
"SQLite as a document database" - Volland/simple-graphgithub.com So the same middle ground of node table with id and type could looks like CREATE TABLE node ( body TEXT, id INT GENERATED ALWAYS AS (json_extract(body, '$.id')) VIRTUAL type string GENERATED ALWAYS AS (json_extract(body, '$.type'))