TRANSFORM for Array Mapping

Concepts: sqlArrayTransform

Lambda Syntax Lambda functions in SQL use arrow notation: element -> expression. The element name is arbitrary and scoped to the lambda body. String Transformations Lambda expressions can apply string functions to every element: Each tag is converted to uppercase. This pattern is useful for normalizing user-generated content before analysis. Complex Expressions Lambda expressions like this are the foundation of in-array transformations. The original array remains unchanged, and the result is a new array ready for downstream use. Remember that every element in the result array corresponds to exactly one element in the input array. TRANSFORM never changes the length of the array.