chore: Updates to support Python up to 3.12

[bmtcril]

Description:

CI and fixes to support Python 3.8 - 3.12.

Closes #397

Merge checklist:

• [ ] All reviewers approved
• [x] CI build is green
• [x] If adding new checks, followed how_tos/0001-adding-new-checks.rst
• [x] Changelog record added (if needed)
• [x] Documentation updated (not only docstrings) (if needed)
• [x] Commits are squashed