René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support (non-legacy) SQL nested data types","articleBody":"`STRUCT\u003ct\u003e` and `ARRAY\u003ct\u003e` seem to be the types.\n\nSee #2342. h/t to @c0b for filing.\n\n---\n\nFrom #2585: [Sample app that reproduces this](https://github.com/GoogleCloudPlatform/python-docs-samples/blob/176f161cae3d4f01b01456a6e403faf6645414a1/bigquery/cloud-client/simple_app.py)\n\nStacktrace:\n\n``` python\nTraceback (most recent call last):\n  File \"simple_app.py\", line 57, in \u003cmodule\u003e\n    query_shakespeare()\n  File \"simple_app.py\", line 47, in query_shakespeare\n    page_token=page_token)\n  File \"lib/python2.7/site-packages/google/cloud/bigquery/query.py\", line 401, in fetch_data\n    rows_data = _rows_from_json(response.get('rows', ()), self.schema)\n  File \"lib/python2.7/site-packages/google/cloud/bigquery/_helpers.py\", line 98, in _rows_from_json\n    for item in cell['v']])\n  File \"lib/python2.7/site-packages/google/cloud/bigquery/_helpers.py\", line 61, in _record_from_json\n    for subfield, cell in zip(field.fields, value['f']):\nKeyError: 'f'\n```\n\n---\n\nStepping into the debugger:\n\n``` python\nipdb\u003e value\n{u'v': {u'f': [{u'v': u'hamlet'}, {u'v': u'5318'}]}}\nipdb\u003e field.__dict__\n{'field_type': u'RECORD', 'description': None, 'name': u'title', 'fields': [\u003cgoogle.cloud.bigquery.schema.SchemaField object at 0x7f4ba9227550\u003e, \u003cgoogle.cloud.bigquery.schema.SchemaField object at 0x7f4ba9227690\u003e], 'mode': u'REPEATED'}\n```\n\n(Added by @dhermes)\n","author":{"url":"https://github.com/dhermes","@type":"Person","name":"dhermes"},"datePublished":"2016-09-19T22:08:35.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":22},"url":"https://github.com/2354/google-cloud-python/issues/2354"}