🪲 CJU fails on ARRAY_AGGed field

[joocer]

SELECT pid 
FROM (
  SELECT * FROM $planets 
  LEFT JOIN (
    SELECT ARRAY_AGG(id) AS pids, planetId 
    FROM $satellites 
    GROUP BY planetId
  ) AS sats 
  ON sats.planetId = $planets.id
) as satellites 
CROSS JOIN UNNEST(pids) AS pid