select_react.js

function select_framework(r, emit) {
  try{
    var package=JSON.parse(r.content);
    if(package && package.dependencies){
      var deps = Object.keys(package.dependencies);
      if(deps.indexOf("react")>=0){
        var row = {id:r.id, repo:r.repo, name:package.name};
        deps.forEach(function(dep){
          emit(Object.assign({}, row, {dependency : dep, isDev : 0 }));
        });
        Object.keys(package.devDependencies).forEach(function(dep){
          emit(Object.assign({}, row, {dependency : dep, isDev : 1 }));
        });
      }
    }
  }
  catch(ex){
  }
}

bigquery.defineFunction(
  'select_framework',
  ['id', 'repo', 'content'],
  [{'name': 'id', 'type': 'string'}, 
   {"name" : "repo", "type" : "string"}, 
   {"name" : "name", "type" : "string"}, 
   {"name":"dependency", "type" : "string"},
   {"name":"isDev", "type" : "integer"}
  ],
  select_framework
);

SELECT repo, name, dependency, isDev
FROM
  select_framework(
  SELECT contents.id id, files.repo repo, contents.content content
  FROM (
    SELECT id, FIRST(repo_name) repo
    FROM
      [bigquery-public-data:github_repos.files]
    WHERE
      path = 'package.json'
    GROUP BY
      id ) files
  JOIN
    [bigquery-public-data:github_repos.contents] contents
  ON
    files.id=contents.id )