Hey all,
Has anyone experienced where supabase's array_agg function is returning the wrong order in the array?
For example, the first screenshot is non-aggregated and we can see here a nickname for each corresponding user_id.
However in the second screenshot when I tried to aggregate them into an array, the order is not correct (i.e. James has user_id of 3ce... which belongs to Steven based off the first screenshot).