alternative.json

[
  {
    "f0_": "202863",
    "entries": "getEntriesByType(\"resource"
  },
  {
    "f0_": "4454",
    "entries": "getEntriesByType('resource"
  }
]

alternative.sql

SELECT
  COUNT(entries), entries FROM (
  SELECT
    page,
    url,
    REGEXP_EXTRACT(body, r'i:getEntriesByType\([\"\']resource)') AS entries
  FROM
    [httparchive:har.2016_09_01_chrome_requests_bodies]
  WHERE
    body CONTAINS 'getEntriesByType' )
WHERE
  entries IS NOT NULL
GROUP BY entries

getEntriesByType.sql

SELECT count(entries), entries FROM (
  SELECT page, url, 
    REGEXP_EXTRACT(body, r'(getEntriesByType\([\"\']resource)') AS entries
  FROM [httparchive:har.2016_09_01_chrome_requests_bodies] 
  WHERE body CONTAINS 'getEntriesByType' IGNORE CASE
) 
WHERE entries IS NOT null
GROUP by entries

results.json

[
  {
    "f0_": "4454",
    "entries": "getEntriesByType('resource"
  },
  {
    "f0_": "202863",
    "entries": "getEntriesByType(\"resource"
  }
]

Potentially dumb question, but wouldn't the "IGNORE_CASE" apply to 'getEntriesByType' rather than the regexp?