Hey, I'm working on implementing a new UNNEST() operation that does what it says, unnests arrays. But here the trick would come when there are multiple UNNESTS() in the select list. Let me explain the desired behaviour with an example:
Let's assume the following table: [image: Screenshot 2021-09-10 at 19.58.53.png] An the following query: SELECT id, UNNEST(arr1), UNNEST(arr2) FROM tbl; Here the expected result is to not produce a join on the two arrays as we would with the original way of giving them in the select lit, but to put the values of the arrays "next to each other" like this: [image: Screenshot 2021-09-10 at 19.59.04.png] I have investigated some options how this could be implemented and created a doc for my notes. Let me share this with the community so that people can share their preference. Any feedback is welcome! https://docs.google.com/document/d/184EKJwMME4SNzyfOTueI-nz-IL-WUiBeaS8Zhi2XzMo/edit?usp=sharing Cheers, Gabor
