Formatting output of Query as ARRAY

#1

I have a query that gets me all tract id’s of a farm which are stored in tract_info doc. the query i use is something like that

SELECT tract_id
from Contacts c
USE KEYS ["tract_info::35807DA0-7881-421C-81CF-F0AC1F99E5F0","tract_info::B063A42D-6C90-4060-95E6-0BAC11804767"]

which returns data like this

[ 
  { "tract_id": [8071 ]},
  { "tract_id": [ 12979,  12980, 12981, 12982, 13255, 13260, 13261 ] }
]

is there a way to return it as a single array like this

[ 
  { "tract_id": [8071, 12979,  12980, 12981, 12982, 13255, 13260, 13261 ] }
]
#2
SELECT   ARRAY_FLATTEN(ARRAY_AGG(tract_id),1) AS tract_id
from Contacts c
USE KEYS ["tract_info::35807DA0-7881-421C-81CF-F0AC1F99E5F0","tract_info::B063A42D-6C90-4060-95E6-0BAC11804767"]
#3

Works like a charm as always