IN()表达式中的nodejs bigquery参数化查询

const { BigQuery } = require('@google-cloud/bigquery');

async function runQuery() {
  const projectId = 'your-project-id';
  const datasetId = 'your-dataset-id';
  const tableId = 'your-table-id';

  const bigquery = new BigQuery({ projectId });

  const values = ['value1', 'value2', 'value3']; // 要匹配的值列表

  const query = `
    SELECT *
    FROM \`$projectId.$datasetId.$tableId\`
    WHERE column_name IN UNNEST(@values)
  `;

  const options = {
    query: query,
    params: {
      values: values,
    },
  };

  const [rows] = await bigquery.query(options);

  console.log('Query Results:');
  rows.forEach(row => {
    console.log(row);
  });
}

runQuery().catch(console.error);