The example creates a JOIN INDEX with portions of a JSON instance extracted by JSONExtractValue.
CREATE JOIN INDEX json_table_ji AS SELECT j.JSONExtractValue('$.name') AS Name, j.JSONExtractValue('$.age') AS Age FROM json_table;