[BigQuery] Option to set `useLegacySql` to false on queries

[kelvinabrokwa]

My use case here is that there is a certain query that errors on legacy SQL (internal bug) and disabling it will allow the use of standard SQL which fixes it.

see https://cloud.google.com/bigquery/docs/reference/v2/jobs#resource-representations (find configuration.query.useLegacySql)

I'm happy to submit a PR is this option makes sense.

[tseaver]

@kelvinabrokwa Thanks for the report! We'd be glad to review / merge a PR for that feature.

[dhermes]

@tseaver I can tackle this, sound good?

[tseaver]

@dhermes Sure, if @kelvinabrokwa doesn't already have it in progress.

[kelvinabrokwa]

@dhermes go for it! 😄

[kelvinabrokwa]

@dhermes any progress?

[dhermes]

Doing it now. Sorry for the delay.

[kelvinabrokwa]

@dhermes no worries! Thank you! 😄

[tseaver]

Via #1992.

[kelvinabrokwa]

@dhermes @tseaver thank you!