Python 3.14 support

[dantownsend]

I don't think any code changes are required - we just need to update our CI, setup.py etc.

This also means dropping python 3.9.

See this similar issue for Python 3.13:

#1094

[bymoye]

Hi, maybe it’s time to start adding the new uuidv7() feature added in pgsql18!

[dantownsend]

Hi, maybe it’s time to start adding the new uuidv7() feature added in pgsql18!

Yes, now would be a good time - Python 3.14's uuid library also has uuid7 support too. We can tackle it in a separate PR, but definitely worth exploring.

[dantownsend]

Resolved by #1270