Migrate to using new bigquery go package

[djohnson-aperture]

What would you like to be added?

What is the feasibility of migrating to using their newer library?
https://pkg.go.dev/cloud.google.com/go/bigquery

It seems to offer a much stronger typing support, especially regarding parameter types.
Currently you can't pass a limit param as a number, because the marshalling fails due to expecting QueryParameterValue.Value to be string, when a number is fully supported by BiqQuery.

[ohaibbq]

I'll take a look. Its nice that the typing is updated.

Are these issues + linked pr related to the bug you're encountering?
goccy#315

[djohnson-aperture]

Perhaps. I'm using node to interact with it, so the syntax looks a bit different from my end. But essentially, I'm migrating tests from using a cloud table to using the emulator, so I'm sure that the syntax function in a production-like environment, but fails in this case.

The most specific instance is trying to send in a query like so:

{
  "query": "select * from `dataSetId.tableId` order by column asc limit @limit",
  "params": { "limit": 10 }
}

The emulator has a fit trying to unmarshal the 10 (Which is a number in the json) to a string.
My interim solution is to just proxy the library functions and stringify all the params properties, which gets things working again.

[ohaibbq]

This has been resolved in #67. I'll get it merged and released tomorrow.

[ohaibbq]

Released in v0.6.6-recidiviz.3.5