Snowflake: how to form a string from an ARRAY with OBJECT types inside?

I have a column TAGS of type ARRAY in table ITEM that looks like this:

As you can see, the number of elements inside the ARRAY does not match. What I want is to construct a string for each row, that gets only the Name and ID of all elements, separated by the character ,. This is the desired result:

How can I do that in Snowflake? Ideally, I would like to use it in a SELECT statement.

I am able to figure this out. The trick is to use a combination of LATERAL FLATTEN and LISTAGG. A requirement is the table must have an ID associated with a row (which can be easily generated):

Then we can use:

select list_agg(value:"Name"::varchar || ': ' || value:"ID"::varchar, ', ')
from ITEM,
lateral flatten(input => ITEM.TAGS)
group by ID;