JSON not a valid type for parameterized query

### Summary

When using parameterized queries with `NULLABLE` values one has to provide the `types` field in case a parameter is null.
The check `getTypeDescriptorFromProvidedType_` fails with `Invalid type provided: "JSON"`.
<details>
<summary>Stacktrace</summary>

```
>  Error: Invalid type provided: "JSON"
>      at BigQuery.getTypeDescriptorFromProvidedType_ (Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\build\src\bigquery.js:741:19)
>      at BigQuery.valueToQueryParameter_ (Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\build\src\bigquery.js:851:38)
>      at BigQuery.createQueryJob (Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\build\src\bigquery.js:968:55)
>      at BigQuery.wrapper (Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\node_modules\@google-cloud\promisify\build\src\index.js:30:35)
>      at BigQuery.query (Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\build\src\bigquery.js:1218:14)     
>      at Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\node_modules\@google-cloud\promisify\build\src\index.js:57:28
>      at new Promise (<anonymous>)
>      at BigQuery.wrapper (Y:\[REDACTED]\backend\functions\node_modules\@google-cloud\bigquery\node_modules\@google-cloud\promisify\build\src\index.js:42:16)
>      at Y:\[REDACTED]\backend\functions\lib\[REDACTED]\import.js:40:50
>      at Array.map (<anonymous>)
```
</details>

Looking at the sourcecode it looks like the type `JSON` was not implemented.
https://github.com/googleapis/nodejs-bigquery/blob/4ebe5da079a8347e60a2e6294f37c6380e2d24c8/src/bigquery.ts#L989-L1008

even though it should have been according to the comment
> // The list of types can be found in src/types.d.ts

where it actually can be found:
https://github.com/googleapis/nodejs-bigquery/blob/4ebe5da079a8347e60a2e6294f37c6380e2d24c8/src/types.d.ts#L3592-L3611

### Steps to reproduce
Run a parameterized query with a column of datatype JSON/NULLABLE
  
  ```ts
  new BigQuery().query({
    query: `
      INSERT INTO
        database.table (data)
      VALUES
       (@data)
    `,
    params:  { data: null },
    types: { data: "JSON" },
  })
  ```
  
<details>
<summary>Environment</summary>

```
- OS: Windows
- Node.js version: 18.13.0
- npm version: 9.8.1
- `@google-cloud/bigquery` version: 7.3.0
```
</details>

<sub>Sidenote: Same is true for the new datatype `RANGE`</sub>


	static getTypeDescriptorFromProvidedType_(
	providedType: string \| ProvidedTypeStruct \| ProvidedTypeArray
	): ValueType {
	// The list of types can be found in src/types.d.ts
	const VALID_TYPES = [
	'DATE',
	'DATETIME',
	'TIME',
	'TIMESTAMP',
	'BYTES',
	'NUMERIC',
	'BIGNUMERIC',
	'BOOL',
	'INT64',
	'FLOAT64',
	'STRING',
	'GEOGRAPHY',
	'ARRAY',
	'STRUCT',
	];

	typeKind?:
	\| 'TYPE_KIND_UNSPECIFIED'
	\| 'INT64'
	\| 'BOOL'
	\| 'FLOAT64'
	\| 'STRING'
	\| 'BYTES'
	\| 'TIMESTAMP'
	\| 'DATE'
	\| 'TIME'
	\| 'DATETIME'
	\| 'INTERVAL'
	\| 'GEOGRAPHY'
	\| 'NUMERIC'
	\| 'BIGNUMERIC'
	\| 'JSON'
	\| 'ARRAY'
	\| 'STRUCT'
	\| 'RANGE';
	};

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

JSON not a valid type for parameterized query #1320

Summary

Steps to reproduce

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

JSON not a valid type for parameterized query #1320

Description

Summary

Steps to reproduce

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions