From locally running python, what's the best way to run a query and download the result?
Supposedly Manual:Pywikibot/MySQL can't work with Quarry, except from toolserver.
Topic on Talk:Quarry
There has never been support for Quarry in Pywikibot, but recently support for Wikimedia Superset was added. Use SupersetPageGenerator in code or -supersetquery from command line.
Interesting suggestion: I should try to figure out how to get Superset to work. The access to create new datasets seems to be limited.
Is there a way to trigger the update of query from python and then load the result of the most recent run without knowing the run number?