Arrays are a really nice feature. As an aside, you can replace this line: array_to_string(array_agg(projects.name), ',')) with this: string_agg(proje

Arrays are a really nice feature. As an aside, you can replace this line: array_to_string(array_agg(projects.name), ',')) with this: string_agg(projects.name, ',')