[PKG SUPPORT] changes for support of `flake >=6.0.0` (and Python 3.12, implicit)

[valeriupredoi]

Hi @carlio et al (the good Prospector folk), here's your (annoying) friendly pkg maintainer - in order for Prospector to be built with Python 3.12, there are three direct dependencies that need to change lower and upper pin bounds (well, upper bound is not 100% needed, but safe):

- mccabe >=0.7.0,<0.8.0
- pycodestyle >=2.11.0,<2.12.0
- pyflakes >=3.1.0,<3.2.0

these are unfortunately dictated by flake8 >=6. Are these possible at the moment? If so, I can fire up a rebuild, and (AFAIK) even with a pylint=2.17.7 we can get us a python 3.12 supported build, so the issue of supporting pylint >=3 is not that pressing, Python 3.12-wise. Cheers muchly! :beer: