use faster query_and_wait method when available to skip BQ Storage API if all query results are already available #710
Description
Similar to googleapis/python-bigquery#1745, pandas-gbq should benefit from the optimizations done in googleapis/python-bigquery#589.
This might require a progress bar feature in query_and_wait if we want to keep the progress bar for waiting for the query to finish, but we need to be careful when introducing such a progress bar to avoid timing out API requests too soon.