How do I aggregate values into an array?

Druid SQL supports ARRAY_AGG and STRING_AGG. Here’s a simple ARRAY_AGG example:

SELECT ARRAY_AGG(First || ' ' || Last) AS Name returns:

Screen Shot 2022-07-15 at 11.59.11 AM

For a little more context read here, here, and here.