如何在BigQuery中以类似通配符的方式查询多个结构

SELECT * FROM (
  SELECT * FROM `project.dataset.table_1`
  UNION ALL
  SELECT * FROM `project.dataset.table_2`
  UNION ALL
  SELECT * FROM `project.dataset.table_3`
)
WHERE column_name LIKE '结构%'

from google.cloud import bigquery

client = bigquery.Client()

table_prefixes = ['table_1', 'table_2', 'table_3']
wildcard = '结构%'

query = ''
for prefix in table_prefixes:
    table = f'`project.dataset.{prefix}`'
    if query:
        query += ' UNION ALL '
    query += f'SELECT * FROM {table} WHERE column_name LIKE "{wildcard}"'

query_job = client.query(query)
results = query_job.result()

for row in results:
    # 处理查询结果
    pass