KT showing how to transform arrays

Arrays are a common data type in structured formats like JSON. Users often want to transform arrays in various ways, such as flatten in separate rows, combine elements into a single field, etc. It might be useful to have a KT which shows how to transform arrays containing both primitive types and structs using array indexing operators, and functions such as `EXPLODE` and `ARRAY_JOIN`.