Embedded hal dependency bigquery

hal-query.sql

# Run on https://console.cloud.google.com/bigquery

# Fetch all projects on crates.io

SELECT 
  projects.name, projects.platform , projects.latest_release_number, projects.dependent_projects_count, 
  dependencies.dependency_requirements as hal_version
FROM
  `bigquery-public-data.libraries_io.dependencies` dependencies
  
INNER JOIN (
  SELECT name, platform, dependent_projects_count, latest_release_number
  FROM `bigquery-public-data.libraries_io.projects`
  WHERE language = "Rust"
) projects
ON
  dependencies.project_name = projects.name AND dependencies.version_number = latest_release_number
WHERE
  dependencies.dependency_name = "embedded-hal"
ORDER BY
  projects.dependent_projects_count DESC
;