in reply to Remote SQL queries

Either move the renderer to the database machine, or move the data to the renderer. Since the former is out of the question you'll have to do the latter ;-)

Get a bulk download of the necessary data, then use a local copy of MySQL or DBD::SQLite and run your renderer off that.