https://github.com/rogerjdeangelis/utl-stack-columns-and-count-values-using-with-and-without-sql-arrays-in-sas-r-and-python ...

ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the provided expression arguments. All arguments must be of the same type. ARRAY_APPEND(arr, expr) Appends the expression to the array. The ...