MYSQL module add "Stored Proceedure Call" option

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. :slight_smile: