yhat / pandasql

sqldf for pandas
MIT License
1.34k stars 185 forks source link

Added the DELETE and UPDATE clause support #85

Open TheGlobalist opened 4 years ago

TheGlobalist commented 4 years ago

Hello, For my needs, I've decided to add support for DELETE and UPDATE clauses. Maybe I've written them in a bad way, but I hope it might be of good use for others! :)

SteveScott commented 4 years ago

Oh this would be amazing!

wolfram-laube commented 3 years ago

Please verify/accept this PR, it would greatly enhance functionality

cadraincm commented 1 year ago

I patched it further to support inserts. it worked but I did not thoroughly test it

(?:FROM|JOIN|UPDATE|INSERT INTO)