Snowflake is a whole new level of data science engine. For example - arrays! https://sqlkover.com/cool-stuff-in-snowflake-part-3-split-and-flatten/