UQL to transform column content to column names

[KevinDW-Fluxys]

Hi,

I have the following data, where i would like to transform the data inside the name field to be a column name, and the value field to be the value of that column.

Source data (simplified)

{
    "application": "name1"
    "spec": {
        "info": [
            {
                "name": "Owner",
                "value": "owner1"
            },
            {
                "name": "Revision",
                "value": "revision1"
            }
        ]
    }
},
{
    "application": "name2"
    "spec": {
        "info": [
            {
                "name": "Owner",
                "value": "owner1"
            },
            {
                "name": "Revision",
                "value": "revision2"
            }
        ]
    }
},
...

Desired result:

Application	Owner	Revision
name1	owner1	revision1
name2	owner1	revision2

I was able to get close by expanding spec.info and then projecting the values, but i get stuck at having a name and a value column where owner and revision are repeating values.