Join based on keys and arrays

SQL++
2 
SELECT OBECT lv.name:lv.obj FOR lv IN (
       SELECT op.name, OBJECT v.id:v.val FOR v IN ag END obj
       FROM default AS d
       LET op = OBJECT_PAIRS(d.chart_apps)
      WHERE ....
      GROUP BY op.name
      LETTING ag =  ARRAY_AGG({"id": META(d).id, op.val}) ) END ;