Google-cloud-go: bigquery add use standard sql

[albertog]

I have try to use standard sql and I do not find please can you add this awesome feature.

[jba]

We'll look into it.

[okdave]

@albertog can you give more details about exactly what you're trying to achieve? Are you saying you'd like the package to be compatible with datastore/sql, or that you'd like the query syntax to change?

[albertog]

My request is to allow use new syntax sql

https://cloud.google.com/bigquery/sql-reference/enabling-standard-sql

thanks

On Wed, Jul 6, 2016 at 3:50 PM, Dave [email protected] wrote:

@albertog https://github.com/albertog can you give more details about
exactly what you're trying to achieve? Are you saying you'd like the
package to be compatible with datastore/sql
https://golang.org/pkg/database/sql/, or that you'd like the query
syntax to change?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/GoogleCloudPlatform/gcloud-golang/issues/281#issuecomment-230776919,
or mute the thread
https://github.com/notifications/unsubscribe/AADNegvggfI-IePUQHvh_JbGNVeSoCakks5qS7KWgaJpZM4JBQi_
.

[chrisprobst]

What's the status of this issue? I need this option. Any workarounds?

[jba]

It's going to happen by September 30.

[chrisprobst]

@jba Is this still true? :-)

[jba]

It's there: https://godoc.org/cloud.google.com/go/bigquery#QueryUseStandardSQL. We forgot to mark the bug fixed. (It's a duplicate of #326.)

Fixed by 9c1098a4debc9bf1073ed0e4872b12bd916243d8.

[chrisprobst]

Sweet, thanks.

[chrisprobst]

@jba I'm still not sure, if this is fixed.

I'm not sure how QueryUseStandardSQL() can be used for querying, client.Query().Read(, ..) only accepts ReadOptions.

I'm probably doing something wrong, any ideas ?

Thanks!

EDIT: Never mind, I'm using the .Copy() with an empty &Table{}. Not sure if this correct tho.

[adams-sarah]

@shantuo might be able to help.

[shantuo]

Yes, Copy() should work. But it may change before BigQuery going to Beta.