Is it possible to select from an array of records? I have a function that returns an array of records (generated dynamically in the function, not from an underlying table), and I want to join that result set to another table in a view. In Oracle, this would be considered a pipelined function. Is there any concept like this in SingleStore?
Thank you!