Thoughts on Peter Bartholomew's BYROWλ solution to BYROW that can return arrays of arrays?

GitHub Gist

MS Community Hub Discussion

Fed up with #CALC errors when developing solutions seem like a natural use for BYROW, but need an array result per row, I started building some utility functions for cramming results into thunks and then unpacking them later.

Then I thought, "I should just build a generalized BYROW solution that handles array results."

Then I thought, "I bet someone has built this."

And now here I am looking at Peter Bartholomew's BYROWλ (and friends) and wondering, "Is this too far?"

Is anyone else here using something like this? Why did Microsoft decide that BYROW should return scalar values per row? That's rhetorical, of course. No one knows the answer to that question.

I'm just so tired of #CALC errors when BYROW feels like such a natural fit for a problem. I'm mostly curious if others are using functions like these, just relying on thunks, or simply avoiding BYROW/BYCOL when array result are needed?