Is it really the case? Assume you have column with schema name and one with json object. And your materialised view/JsonExtract can be dispatched by schema name for a row.

I see the only suboptimal part if different schemas have different types for the same field and it has to convert it to String.