productDynamicFields, Dashboard

Fantastic - thanks.

Sorry but I think I need to query the database, because I want to pull in order, product and customer details from different tables. My Dashboard app is basically as follows:

<?php
    // set up database connection
    $API  = new PerchAPI(1.0, 'interact_orders');
    $DB = PerchDB::fetch();

    // function to convert array to a nicely-formatted table
    function build_table($array){
        // start table
        $html = '<table>';
        // header row
        $html .= '<tr>';
        foreach($array[0] as $key=>$value){
            $html .= '<th>' . $key . '</th>';
        }
        $html .= '</tr>';

        // data rows
        foreach( $array as $key=>$value){
            $html .= '<tr>';
            foreach($value as $key2=>$value2){
                $html .= '<td>' . $value2 . '</td>';
            }
            $html .= '</tr>';
        }

        // finish table and return it
        $html .= '</table>';
        return $html;
    }
    // end function

    // orders by sku
    echo "<h3>Orders by training course</h3>";
    $Statuses = new PerchShop_OrderStatuses($API);
    $sql = 'SELECT i.orderID as "ORDER ID", p.sku as "SKU", 
        SUM(i.itemQty) AS "QUANTITY", p.title as TITLE, p.productDynamicFields as "DYNAMIC FIELDS", c.customerFirstName as "CUSTOMER FIRST NAME", c.customerLastName as "CUSTOMER LAST NAME", c.customerEmail as "CUSTOMER EMAIL" 
        FROM '.PERCH_DB_PREFIX.'shop_customers AS c INNER JOIN '.PERCH_DB_PREFIX.'shop_orders AS o USING (customerID) 
        INNER JOIN '.PERCH_DB_PREFIX.'shop_order_items as i USING (orderID) 
        INNER JOIN '.PERCH_DB_PREFIX.'shop_products as p USING (productID) 
        WHERE o.orderStatus IN ('.$DB->implode_for_sql_in($Statuses->get_status_and_above('paid')).') 
        AND o.orderDeleted IS NULL 
        GROUP BY p.sku, i.orderID 
        WITH ROLLUP';

    $result1 = $DB->get_rows($sql);

    if ($result1) {
        echo build_table($result1);
    }

?>  

This presents all the productDynamicFields in one column of the finished table. Is there any way I can present columns in my finished table for my specific extra fields like date, venue and duration? Perhaps by amending the database query or by manipulating the $result1 array? I've been playing around with json decode to no effect - along these lines:

$fields = PerchUtil::json_safe_decode($result1['DYNAMIC FIELDS'], true);

I'm getting this in debug: Undefined index: DYNAMIC FIELDS