8

Add support for more SQL directives in SQL Query action

Hi Joao, can I ask for adding support for new SQL directives to the 'SQL Query' action?

The main one I was looking for in a project I'm working on is: DROP TABLE. (fails reporting issues with db write permissions)

And, if possible, would be great if you could add more than the one I wrote you before.

Only the following are currently supported when Pent added that action: INSERT INTO, UPDATE, CREATE TABLE, DELETE FROM, ALTER TABLE

Thank you ;)

Follow

1 reply

Votes Newest Oldest
S

I think the doc should be changed to say just CREATE, INSERT, UPDATE, DELETE, ALTER. The current text gives impression of restrictions that do not exist, e.g. CREATE TRIGGER, INSERT OR REPLACE all work fine. DROP seems to be a problem as you mentioned.

Comment
Reply