Can we have a table type variable so as to avoid repeat SQL calls?
Our developers indicated it would be very useful to have a table type variable or something similar (e.g. structure or user defined type) to store SQL statement results and so avoid repeated calls to the database.
Adam Jackson commented
My name is Adam Jackson and I'm a Product Manager with Windward. Thanks for reaching out with your suggestion.
We like this idea but we're going to see if this gets more traction over the next few months before diving in as this is no small feat for us to accomplish.
Please let us know if there's anything else we can do for you!