Oracle Database 23ai introduced JRDV: JSON -Relational Duality Views. This ground-breaking functionality give you the flexibiilty of JSON documents as well as all the advantages of the relational model.

A customer uses one centralised APEX Monitoring application to keep an eye on multiple satellite installations of APEX applications for different customers. Runtime data of these APEX applications are sent from the satellites to the Monitoring application using PL/SQL functions to code and decode the data and ORDS as the bridge in between.

Taking this real life project as a starting point we will demonstrate how the use of JSON-Relation Duality Views can have a huge impact on the complexity - and therefore maintainability - of the codebase.