thats right distinct output represent multiple rows and existing post aggregation functions can only act of one row

Kishore, would you please point me to the repo url where I can find those post aggregation functions to see how can I help adding support for multiple rows?

any transform function can be a post-aggregation function

Yeah, I was thinking of extending the definition of CONCAT to allow multiple values in a column and a separator instead of two columns and a separator