Is your feature request related to a problem? Please describe.

We need to be able to set expiries for the tables, project.dataset.tableName, and also option for create vs replace.

Describe the solution you'd like

Ideally the user can optionally pass in a config object like QueryJobConfig. QueryJobConfig has many options such as destination which allows one to set the destination of table and name, but it doesn't seem like it can handle create/replace (it has create_disposition which offers some limited control) and expiry.

Describe alternatives you've considered

N/A. Willem and a few of us briefly discussed this and he played around with the idea of passing in and out sql queries. So one could modify the query and pass it back in.