RETURNS TABLE from procedures
Would it be possible to return a table from a procedure without having to specify each column in the RETURNS () clause? I have a few use cases where that would make my life a lot easier.
Comment actionsOfficial comment
thanks for submitting this feature request. Unfortunately, this would be hard to implement for us. Let me explain the reason: entities in the DV Platform are related in a dependency graph, which we need for our metadata. The return values of a procedure are also part of the metadata, they need to be checked for all objects depending on them. If the return values of a procedure are determined at runtime, it would be impossible to do all of our dependency checks. Therefore implementation of this feature request would be very hard.
We still like the feature you requested, and will put it on our product management system, but unfortunately cannot implement it in the very near future.
Please sign in to leave a comment.