I haven’t tested it myself, but it looks like the OBJECT_AGG function will do what you’ve proposed. https://docs.snowflake.net/manuals/sql-reference/functions/object_agg.html
I wouldn’t say people are bailing on Oracle technologies, more like we are expanding beyond Oracle. Gluent can help organizations move to the new world of Hadoop, and integrate their current datastores with Hadoop regardless of whether they are the “big red stack” or not. Like you said, it’s a great opportunity to learn and to grow beyond Oracle technology.