pearl crag
Hello friends,
As we all know, Directus does not support out-of-the-box feature to execute SQL Stored Procedure. I know the Directus team did that on purpose because of complications with Stored Procedure that might affect Directus features.
Acknowledging that!!! However, I think there are still good use case of having the ability to execute SQL Stored Procedure in Directus Flow. We just need to use it with care! Imagine having an Operation in Directus Flow to execute SQL stored procedure 
!!!
Luckily, custom operation has access to the needed knex object that would allow us to do just that. Hence, I am reaching out to all of the folks out there who are interested for a "small" collaboration project. And to build a custom extension for everyone who is interested in having this tool handy to use in their projects.
Let's lay down some ideas & expectations we can have for this feature:
- a custom operation (named: Execute Stored Procedure) that can be selected on the UI
- when selected, the UI should display necessary input boxes to input parameters (that can be dynamic variables)
- result of the operation is returned and passed on to the next operation in the Directus Flow.
I am a self-taught programmer, who has little experience with Vue & Knex, and this is my first time working on a open source project, but I'm up for the challenge. And please feel free to point out if I am hallucinating, and any issues with my current way of thinking. It is greatly appreciated! Always be learning 😁
Let me know if you are interested!!!
lavish wind
sharp anchor
somber totem