Add official support for Python 3.12

[astrojuanlu]

Description

Kedro itself probably works on Python 3.12 already, it would be nice to declare official support.

However, installing Kedro is one thing, but installing the typical dependencies might not be straightforward. For example, I just tested the spaceflights starter and most of the dependencies have already published precompiled wheels for Python 3.12 (at least for M1 Mac), but two of them are still problematic as of today:

• aiohttp Python 3.12 can't build wheels for aiohttp aio-libs/aiohttp#7739 worked by installing the beta version as advised there, so it will be solved soon (edit: fixed ✔️)
• pyzmq unable to build on mac m1 max zeromq/pyzmq#1907 (M1 specific), didn't work after installing the ZMQ header libraries with mamba (edit: fixed ✔️)

Context

#2815 was already completed, but officially Kedro does not support Python 3.12 yet.

You can use Kedro on Python 3.12 by manually disabling the warning.

Possible Implementation

Wait a bit until at least the spaceflights starter can be safely installed in most mainstream platforms.

Possible Alternatives

Declare Python 3.12 support already, at the cost of creating some grievance of users that then proceed to install some dependencies.

[astrojuanlu]

aiohttp 3.9.0 released

[astrojuanlu]

pyzmq has a fix incoming zeromq/pyzmq#1913

[astrojuanlu]

One last transitive dependency of aiohttp, multidict, is missing 3.12 wheels aio-libs/multidict#887

[astrojuanlu]

All transitive dependencies of Kedro have official support for 3.12. Let's go!

[astrojuanlu]

Now the problem is in the Kedro tests themselves:

• test_overlapping_patterns is not testing anything because it's using a nonexistent called_once_with method. this is currently broken in main, should be marked as xfail or fixed by using assert_called_once_with instead, see Add official support for Python 3.12 #3587 (review)
• test_load_core_config_get_syntax seems to be failing only in Python 3.12, @ankatiyar found that the UserDict interface has changed UserDict __getitem__ behavior change between 3.11.1 and 3.12.0b2 python/cpython#105524 some minor code changes are needed on our side