Finding which PRs have been taken out of the Merge Queue due to failed status checks

🤖 This post includes some LLM-derived content 🤖 In the Renovate project, we use the Merge Queue to merge PRs. If a PR fails its status checks, it will be pulled out of the Merge Queue, and a maintainer will need to re-queue it, if it is a transient error. For those of you unaware, GitHub are having a pretty hard time recently with outages, which means that we're seeing an increase in the number of PRs being pulled out of the Merge Queue due to transient errors due to GitHub's instability (and in rare cases, due to flakiness in our test suite). For a number of these PRs, they're dependency updates that Renovate raises (:yo_dawg:) which means that a maintainer doesn't necessarily see they're unmerged. If we want to find out which PRs are approved, but not merged due to the merge queue un-queuing them, we can use the following GraphQL query: # via Claude Sonnet 5 $ gh api graphql -f query='query { search(query: "repo:renovatebot/renovate is:pr is:open review:approved", type: ISSUE,…