Implement various automations

[wd60622]

I think there could be improvement on the automations. Some ideas that I had are:

• Automatically add labels to PR
  • Could be off of the checked items in PR template
  • Based on the files that were changed Add PR auto labeling #1111
  • label pr same as issue being closed Sync PR labels with closing issues #1113
• Label or close stale issues
• bump version before release. The Narwhals team does something similar. Would be life improvement for @juanitorduz ☺️

Let me know if there are other ideas which could improve our tracking and addressing of issues and PRs

Related to: #1086

[juanitorduz]

Great ideas!

[wd60622]

We can get the labels from the issues from a PR using the following query:

{
  repository(owner: "pymc-labs", name: "pymc-marketing") {
    pullRequest(number: 1096) {
      closingIssuesReferences(first: 10) {
        nodes {
          number
          labels(first: 10) {
            nodes {
              name
            }
          }
        }
      }
    }
  }
}