Third party `requests-cache` breaks Python 3.12 compatibility

[aaronsteers]

Re:

• Fix SQLite concurrency on python 3.12 requests-cache/requests-cache#845

[natikgadzhi]

Is it loud failure or obscure failure? Seems like requests-cache should play nice with 3.12, perhaps we should update this to latest in CDK?

[aaronsteers]

Natik Gadzhi (@natikgadzhi) - It is a more obscure error. The linked issue from `requests-cache repo points specifically to issues with concurrency, which is where it bit us:

It looks like requests-cache is currently compatible with python 3.12, with a few minor exceptions:

• Multiprocess usage with SQLite
• In-memory cache reads responses twice on request
• DeprecationWarning with datetime.utcnow()

Specifically we ran into it as a blocker here:

• fix(concurrent-partition-cursor): Fix cursor comparison error #298

[natikgadzhi]

I’ve googled around, and it seems the problem is in requests-cache SQLite backend. Can we switch to using files backend instead?

[aaronsteers]

Resolved:

• feat: add Python 3.12 and 3.13 support #684