Category "cross-apply"

SQL Server - LEFT JOIN two JSON objects on a common property

I have a table with a column holding the schema (key, type) of a JSON object, and another table with a column holding instances of objects described by that sch