Question: I need a JDBC driver to connect my application to Google BigQuery. I tried CData JDBC driver, but it did not support all types of Standard SQL queries. Are there any other complete options?

Answer: 
The official [JDBC driver for BigQuery](https://cloud.google.com/bigquery/partners/simba-drivers/) should support all types of standard SQL queries.
> 
> Are there any other complete options? 
> 
> 
> 

You can use Query Prefix `#standardSQL` to force use of Standard SQL 

See more details in [Setting a query prefix](https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql#sql-prefix)