As much as you can, I'd try to keep any queries against the SQL database up in the Azure cloud. Any, regardless of if you write them or you use the API, that pull data down locally, are going to be costly. So, if you can create a service or function that does the polling within Azure, you'll be better off.