tylertreat/BigQuery-Python

Standard SQL support

ereli opened this issue · 3 comments

ereli commented

Looking at this it seem that this still uses legacy SQL instead of the new standard SQL
are you considering adding support for Std. SQL instead or in addition legacy SQL?

BigQuery-Python/bigquery/query_builder.py

Line 164 in 96ff0b1

["[%s.%s]" % (dataset, table) for table in tables])

tylertreat commented

I don't have any plans to implement this myself at the moment, but I'm happy to accept PRs.

  • 👍1
ajtkulov commented

actually, it supports StandardSQL:

def query(self, query, max_results=None, timeout=0, dry_run=False, use_legacy_sql=None, external_udf_uris=None)

job_id, _results = client.query('''put standard sql here''', use_legacy_sql = False)

tylertreat commented

@ajtkulov good catch, I forgot that was added. :) #101

  • 👍1