The driver supports both standard and legacy SQL dialects of Google BigQuery. By default, the driver uses standard SQL to execute queries. However, you can change the dialect to legacy SQL either by adding the prefix #legacySQL to a query or by setting the Syntax connection option to legacy (Syntax=legacy).
The following example demonstrates how to use the prefix #legacySQL in a query:
#legacySQL
SELECT ID,name FROM [bigquery-public-data:samples.EMP]
WHERE name CONTAINS "RA";
