Adjusting SQL Select statement ore split collums

[Rudolf]

Hi

i am working on a new Reporting using date receiving via REST.

The generated script:

RestConnectorMasterTable:
SQL SELECT
  "status",
  "__KEY_root",
    (SELECT
      "resultType",
      "__KEY_data",
      "__FK_data",
        (SELECT
          "__KEY_result",
          "__FK_result",
            (SELECT
              "pod",
              "__FK_metric"
           FROM "metric" FK "__FK_metric"),
            (SELECT
               "__KEY_values",
               "__FK_values",
                     (SELECT
                         "@Value",
                         "__FK_values_u0"
                     FROM "values" FK "__FK_values_u0" ArrayValueAlias "@Value")
            FROM "values" PK "__KEY_values" FK "__FK_values")
       FROM "result" PK "__KEY_result" FK "__FK_result")
   FROM "data" PK "__KEY_data" FK "__FK_data")
FROM JSON (wrap on) "root" PK "__KEY_root";

The table i get shows two Rows containing the Data as shown:

 What i want to do is splitting the second Collum in two  ore creating a new table showing 3 collums:

__Key_values | values | timestamp

I tried with with subfield but that did not help me out.

Is there a way to adjust the sql loadscript?

Are there any further infos you need please contact me.

I am looking forward hearing from you

Best Regards

Rudolf