read_gbq should offer an option to save to dataset
Right now `read_gbq` runs a query and retrieves the results into a data_frame. If one wants to also save it into a dataset table, one then has to call `to_gbq` which would stream the results back.

The `bq` command line tool has an option to pass a destination dataset table immediately on query to store the results.

```
cat queries/sample.sql | bq query --format csv 
  --destination_table=collection.table_name > output.csv
```

Ideally `read_gbq` would have an additional option like `destination_table` that could store the results immediately.
