title: JSON_EXTRACT not working with booleans in BigQuery
body: <p>I have a JSON from Firebase that looks like this:</p>
  <pre><code>    {
      'name' : 'starbyone',
      'foo': {'id': 123},
      'somebit': True,
      'bar': {'_a': 123, '_b': 456}
      }
  </code></pre>
  <p>I'm using BigQuery and am tyring to extract 'foo' by using <code>JSON_EXTRACT</code>function:</p>
  <pre><code>SELECT 
      JSON_EXTRACT(json, &quot;$.name&quot;) as Works,
      JSON_EXTRACT(json, &quot;$.foo&quot;) as AlsoWorks,
      JSON_EXTRACT(json, &quot;$.bar&quot;) as DoesNotWork
  FROM schema.table
  </code></pre>
  <p>The issue however, is that the third column (aliased DoesNotWork) simply returns NULL, while 'Foo' will return a string &quot;{'id': 123}&quot;</p>
  <p>I've also tried JSON_VALUE , to no avail.</p>
  <p>What am I doing wrong?</p>
  <p>This simple snippet doesn't seem to work for me either:</p>
  <pre><code>SELECT JSON_EXTRACT(&quot;{'category': 1, 'comments': [], 'free': False,'price': 55&quot;,&quot;$.price&quot;) AS Result 
  </code></pre>