编写SQL脚本，获取BigQuery中所有列的列表并将它们注入到查询中。

SELECT column_name
FROM `project.dataset.INFORMATION_SCHEMA.COLUMNS`
WHERE table_name = 'your_table_name'

DECLARE @columns_list AS NVARCHAR(MAX)
DECLARE @sql AS NVARCHAR(MAX)

SET @sql = N'SELECT @columns_list = STRING_AGG(column_name, '','')
FROM `project.dataset.INFORMATION_SCHEMA.COLUMNS`
WHERE table_name = ''your_table_name'''

EXEC sp_executesql @sql, N'@columns_list NVARCHAR(MAX) OUTPUT', @columns_list OUTPUT

SELECT @columns_list AS columns_list