Jon,
JSON_TABLE is NOT more complex than extracting information from a complex JSON document with YAJL.
In the same way you design your nested data structures, you design the nested COLUMN definitions in the JSON_TABLE Function statement.
We already had the discussion multiple time.
I personally prefer JSON_TABLE over DATA_INTO.
In my classes I teach both methods. RPG with YAJL and DATA_INTO first and after SQL. The majority of my attendees prefer the SQL way.
Birgitta
JSON_TABLE is NOT more complex than extracting information from a complex JSON document with YAJL.
In the same way you design your nested data structures, you design the nested COLUMN definitions in the JSON_TABLE Function statement.
We already had the discussion multiple time.
I personally prefer JSON_TABLE over DATA_INTO.
In my classes I teach both methods. RPG with YAJL and DATA_INTO first and after SQL. The majority of my attendees prefer the SQL way.
Birgitta
Comment