SELECT results.participants.agent AS id, r.result.performance_metrics.irs AS irs, r.result.performance_metrics.vrs AS vrs, r.result.performance_metrics.sr AS sr, r.result.performance_metrics.win_rate AS win_rate, r.result.advanced_metrics.avg_kre AS kre, r.result.advanced_metrics.avg_irp AS irp, r.result.advanced_metrics.avg_vss AS vss FROM results CROSS JOIN UNNEST(results.results) AS r(result);