usingGoogle.Cloud.BigQuery.V2;usingSystem;publicclassBigQueryQueryLegacy{publicvoidQueryLegacy(stringprojectId="your-project-id"){BigQueryClientclient=BigQueryClient.Create(projectId);stringquery=@"            SELECT name FROM [bigquery-public-data:usa_names.usa_1910_2013]            WHERE state = 'TX'            LIMIT 100";BigQueryJobjob=client.CreateQueryJob(sql:query,parameters:null,options:newQueryOptions{UseLegacySql=true});// Wait for the job to complete.job=job.PollUntilCompleted().ThrowOnAnyError();// Display the resultsforeach(BigQueryRowrowinclient.GetQueryResults(job.Reference)){Console.WriteLine($"{row["name"]}");}}}

import("context""fmt""io""cloud.google.com/go/bigquery""google.golang.org/api/iterator")// queryLegacy demonstrates running a query using Legacy SQL.funcqueryLegacy(wio.Writer,projectID,sqlStringstring)error{// projectID := "my-project-id"// sqlString = "SELECT 3 as somenum"ctx:=context.Background()client,err:=bigquery.NewClient(ctx,projectID)iferr!=nil{returnfmt.Errorf("bigquery.NewClient: %w",err)}deferclient.Close()q:=client.Query(sqlString)q.UseLegacySQL=true// Run the query and process the returned row iterator.it,err:=q.Read(ctx)iferr!=nil{returnfmt.Errorf("query.Read(): %w",err)}for{varrow[]bigquery.Valueerr:=it.Next(&row)iferr==iterator.Done{break}iferr!=nil{returnerr}fmt.Fprintln(w,row)}returnnil}

importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.QueryJobConfiguration;importcom.google.cloud.bigquery.TableResult;publicclassRunLegacyQuery{publicstaticvoidmain(String[]args){runLegacyQuery();}publicstaticvoidrunLegacyQuery(){try{// Initialize client that will be used to send requests. This client only needs to be created// once, and can be reused for multiple requests.BigQuerybigquery=BigQueryOptions.getDefaultInstance().getService();// To use legacy SQL syntax, set useLegacySql to true.Stringquery="SELECT corpus FROM [bigquery-public-data:samples.shakespeare] GROUP BY corpus;";QueryJobConfigurationqueryConfig=QueryJobConfiguration.newBuilder(query).setUseLegacySql(true).build();// Execute the query.TableResultresult=bigquery.query(queryConfig);// Print the results.result.iterateAll().forEach(rows->rows.forEach(row->System.out.println(row.getValue())));System.out.println("Legacy query ran successfully");}catch(BigQueryException|InterruptedExceptione){System.out.println("Legacy query did not run \n"+e.toString());}}}

// Import the Google Cloud client libraryconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctionqueryLegacy(){// Queries the U.S. given names dataset for the state of Texas using legacy SQL.constquery='SELECT word FROM [bigquery-public-data:samples.shakespeare] LIMIT 10;';// For all options, see https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/queryconstoptions={query:query,// Location must match that of the dataset(s) referenced in the query.location:'US',useLegacySql:true,};// Run the query as a jobconst[job]=awaitbigquery.createQueryJob(options);console.log(`Job${job.id} started.`);// Wait for the query to finishconst[rows]=awaitjob.getQueryResults();// Print the resultsconsole.log('Rows:');rows.forEach(row=>console.log(row));}

use Google\Cloud\BigQuery\BigQueryClient;/** * Query using legacy sql * * @param string $projectId The project Id of your Google Cloud Project. */function query_legacy(string $projectId): void{    $query = 'SELECT corpus FROM [bigquery-public-data:samples.shakespeare] GROUP BY corpus';    $bigQuery = new BigQueryClient([      'projectId' => $projectId,    ]);    $jobConfig = $bigQuery->query($query)->useLegacySql(true);    $queryResults = $bigQuery->runQuery($jobConfig);    $i = 0;    foreach ($queryResults as $row) {        printf('--- Row %s ---' . PHP_EOL, ++$i);        foreach ($row as $column => $value) {            printf('%s: %s' . PHP_EOL, $column, json_encode($value));        }    }    printf('Found %s row(s)' . PHP_EOL, $i);}

fromgoogle.cloudimportbigquery# Construct a BigQuery client object.client=bigquery.Client()query=("SELECT name FROM [bigquery-public-data:usa_names.usa_1910_2013] "'WHERE state = "TX" '"LIMIT 100")# Set use_legacy_sql to True to use legacy SQL syntax.job_config=bigquery.QueryJobConfig(use_legacy_sql=True)# Start the query and waits for query job to complete, passing in the extra configuration.results=client.query_and_wait(query,job_config=job_config)# Make an API request.print("The query data:")forrowinresults:print(row)

require"google/cloud/bigquery"defquery_legacybigquery=Google::Cloud::Bigquery.newsql="SELECT name FROM [bigquery-public-data:usa_names.usa_1910_2013] "\"WHERE state = 'TX' "\"LIMIT 100"results=bigquery.querysql,legacy_sql:truedo|config|# Location must match that of the dataset(s) referenced in the query.config.location="US"endresults.eachdo|row|putsrow.inspectendend