Specifies whether to use Google BigQuery's Legacy SQL dialect instead of Standard SQL when generating queries.

Data Type

bool

Default Value

false

Remarks

By default, the server uses Standard SQL, which is the recommended and more feature-rich dialect supported by Google BigQuery.

When this property is set to true, the server generates queries using Google BigQuery’s Legacy SQL dialect. Legacy SQL has different syntax and semantics and does not support certain modern features.

Key behavioral differences:

• When UseLegacySQL is set to true, the value of AllowLargeResultSets is used during query generation.
• When UseLegacySQL is set to false, the server uses Standard SQL, and AllowLargeResultSets is ignored. Queries behave as if that property is always enabled.

Enable this property only if your environment requires compatibility with Legacy SQL, such as when working with legacy views, tools, or scripts that depend on that dialect. Standard SQL is generally more performant and flexible and is recommended for most use cases.