Minsky’s 1974 frame-and-slot approach offered a powerful way to model domains but struggled because schemas had to be manually translated into databases and validation rules. LPG Modeler by Volodymyr Pavlyshyn addresses this by compiling a single YAML schema into multiple graph, RDF, and schema formats while preserving constraints and clearly reporting where they cannot be carried forward.

https://www.lpg-modeler.com/index.html

Open Graph Image
www.lpg-modeler.com

LPG Modeler

A VS Code extension for labeled property graph schemas: author them as reviewable YAML, edit them on a canvas, and generate LadybugDB DDL, Neo4j constraints, SHACL shapes and an OWL ontology from one model.

Can #SQL Understand JSON? JSON_EXTRACT in Exasol can return multiple fields from the same JSON string in one call, each mapped to a typed output column through an EMITS clause:


SELECT id,
       e.order_id,
       e.customer
FROM order_events,
     JSON_EXTRACT(json, '$.order_id', '$.customer')
       EMITS (order_id INT, customer VARCHAR(100)) e;

Open Graph Image
www.exasol.com

Can SQL Understand JSON?

Learn how to query JSON with SQL in Exasol using JSON_VALUE and JSON_EXTRACT, then use extracted values alongside relational data.