Query JSON with SQL - Selecting specific array values

[pyrrho]

You could send this to a transformer as per this post's suggestion to filter/parse the data with JS map/filters:

Select data from JSON in nested data

Hey @NickJ, welcome to the community Couldn't get it to work with AlaSQL (which is what the "Query JSON with SQL" query uses). Try a transformer in the meantime: const output = data.map(x => { return { name: x.name, age: x.age, roles: x.roles.map(x => {return x.name}).join(", ") } }) return output

This also seems to be somewhat achievable using the ARRAY function in AlaSQL but you might have to join two separate queries to get the results you want.