Edit Query in local IDE / Integrate redash with IDE

[vhwzx]

I'm writing a lot of queries using Python and SQL on redash.
It would be convenient if I can use IDE (for example, VS Code)，but I haven't find a way to do it, so I have to write code in browser :(.
My question is:
(1) Is their any way to write code in VS Code and execute query within it (may be by calling Redash API) ？
(2) How to upload the code from VS Code to redash (automaticly or by click a button) (to share with others)?
Thanks for your help!