Closes#9177.

This PR adds support for array-like query parameters.

How to test

Run the example from the issue description (slightly modified, see below). Binding an array-like parameter to a parametrized query should not raise an error, and the following should work as expected:

curr.execute(query, (('NY','TX'), ))

Mind that scanning arrays requires usingIN UNNEST(...) construct (docs), thus theUNNEST function needs to be added to the query from the issue description:

query="""  SELECT name, state  FROM `bigquery-public-data.usa_names.usa_1910_2013`  WHERE state IN UNNEST(%s)  LIMIT 2"""

Footnotes

• No nested arrays support, only for arrays of scalar types.
• Detecting if a value is "array-like" is approximate, it primarily tries to cover the most common cases.