The idea is:
If you execute a stored procedure call as a regular query, the results are kind of a mess. The row headers aren’t exposed easily, and the procedure results end up as an “extra” item that needs to be filtered out.
My use case:
Anything there the query is “CALL ”
I think it would be beneficial to add this because:
Eliminates a lot of post processing of results. Also, I think there are cases where a stored procedure can return multiple recordsets, and it’d be good to handle that intelligently.
Any resources to support this?
https://dev.mysql.com/doc/refman/8.0/en/call.html
Are you willing to work on this?
Nobody really wants me to touch code that others will use in production.