php-crud-api icon indicating copy to clipboard operation
php-crud-api copied to clipboard

Support for stored procedures

Open mevdschee opened this issue 7 years ago • 6 comments

We could support stored procedures or similarly "soft" or "fake" stored procedures, which are really SQL files on disk that will be executed on an API endpoint.

mevdschee avatar Sep 04 '18 21:09 mevdschee

+1

mbnoimi avatar Oct 19 '19 17:10 mbnoimi

Is the support for stored procedure added?

AvalerionV avatar Mar 30 '20 18:03 AvalerionV

Would be really great😊👏

franckleveque avatar Aug 11 '20 20:08 franckleveque

Was wondering how i can introduce custom sql queries ? using this api. Like in case i wanna run a very complex query with joins and agregation...

Xsmael avatar Aug 21 '20 17:08 Xsmael

We could support stored procedures or similarly "soft" or "fake" stored procedures, which are really SQL files on disk that will be executed on an API endpoint.

Yeah, I was also thinking about fake views using the same logic, this could be a way for my previous comment, since views are pretty much a simple SQL query. what do you think ?

Xsmael avatar Aug 21 '20 17:08 Xsmael

what do you think ?

I think it would be a great addition to have fake/soft views and procedures.

mevdschee avatar Nov 20 '20 08:11 mevdschee