BigQuery query method should default to standard SQL syntax

[tswast]

I believe this was a GA requirement from the BigQuery engineering team, that the default SQL syntax be changed at the client-library layer for GA. The backend API still defaults to legacy SQL, but they would like to discourage the use of legacy SQL in most applications.

[jdpedrie]

Hi @tswast! This was added in #640. It's described in our documentation here. (pardon the broken markdown, i just opened a PR to fix that).

[tswast]

Okay, thanks. I guess my problem was that https://github.com/GoogleCloudPlatform/php-docs-samples/tree/master/bigquery/shakespeare is using a very old version. Somehow I didn't end up with the latest version when I deleted the composer lock file and tried to reinstall.

Sorry for the noise!

[tswast]

Oh, but I can't seem to install the latest version.

$ php composer.phar install
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - The requested package google/cloud-bigquery ^0.46 exists as google/cloud-bigquery[dev-master, v0.1.0, v0.2.0, v0.2.1, v0.2.2, v0.2.3, v0.2.4, v0.3.0, v0.3.1] but these are rejected by your constraint.

My composer.json is

$ cat composer.json
{
    "require": {
        "google/cloud-bigquery": "^0.46"
    },
    "require-dev": {
        "phpunit/phpunit": "~4"
    }
}

That package name seems to match the installation instructions at https://github.com/GoogleCloudPlatform/google-cloud-php-bigquery

[dwsupplee]

0.46 is the version of the "umbrella" package which installs every component. When installing just BQ itself you will want to relax the version constraint down to 0.3.1

[tswast]

Ah, gotcha. Might be worth putting a badge on https://github.com/GoogleCloudPlatform/google-cloud-php-bigquery with the latest version?

[jdpedrie]

@tswast that's a great idea!

[tswast]

googleapis/google-cloud-php-bigquery#1

[jdpedrie]

@tswast thanks for the PRs. However, those repos are Read-Only splits from this one! The file you're looking for is here.