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 property 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";
Note: In both standard and legacy SQL dialects, some of the identifiers, the names associated with SQL objects, are case-sensitive. For more information about identifiers and the complete list of case-sensitive identifiers, refer to the Google BigQuery documentation.