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.
This was too long ago for me to remember what I did, sorry.
Are you self hosting? If so, you could install the mysql2 Node module and write a little script for the code module to make your stored procedure call, process the results, and output them in a format that you can use in the rest of your workflow.
There seem to be a lot of situations where “a little code” is a much better answer than “no code” which is why I like n8n so much more than Make.