Would be great if there was a way to support list_agg from redshift. For example:
listagg(u.first_name || ’ ’ || u.last_name, ', ')
within GROUP (ORDER BY u.last_name ASC, u.first_name ASC, u.id ASC)
Perhaps this could be externalized as a secret function that gets passed directly to the datastore. So:
listagg... returns varchar(256) } this way the query parser wouldn’t have to support every goofball feature of everything everywhere.
This might give us group_concat as well.