feat: Add overwrite or overwrite-delete-stale to BigQuery

[soren-olympus]

Which problem is this feature request solving?

Get incremental syncs in BigQuery destination plugin.

Describe the solution you'd like

Add write or overwrite-delete-stale write modes for BigQuery destination plugin.

Pull request (optional)

• I can submit a pull request

[hermanschaaf]

@soren-olympus write and overwrite-delete-stale write modes are not a prerequisite for incremental syncs, and that should work today with append mode already.

I'm saying this partly because I don't know if it's possible to implement overwrite-delete-stale mode in BigQuery - the BigQuery streaming buffer disallows deletes, so delete-stale syncs would have to be spaced at least several hours apart, and may still run into errors or inconsistencies even then. We can do more research, but this is what I remember from my initial attempts to implement this feature.

[soren-olympus]

Appreciate this note!!