The various packages should be upgraded progressively to avoid a future situation when e.g. python itself is not supported and we get stuck in antique/vulnerable libraries. This can lead to clearer code as the libs generally move to python typings. Performance could be improved as well, eliminating the need for some bottleneck workaround like today.
I had a quick look and we e.g. have https://docs.sqlalchemy.org/en/20/index.html which can use https://www.psycopg.org/psycopg3/docs/basic/index.html. fastapi/pydantic is frequently updated as well. So far the only abandoned library I saw is https://pypi.org/project/sqlalchemy-views/ from which we only use a pair of primitives.
The various packages should be upgraded progressively to avoid a future situation when e.g. python itself is not supported and we get stuck in antique/vulnerable libraries. This can lead to clearer code as the libs generally move to python typings. Performance could be improved as well, eliminating the need for some bottleneck workaround like today. I had a quick look and we e.g. have https://docs.sqlalchemy.org/en/20/index.html which can use https://www.psycopg.org/psycopg3/docs/basic/index.html. fastapi/pydantic is frequently updated as well. So far the only abandoned library I saw is https://pypi.org/project/sqlalchemy-views/ from which we only use a pair of primitives.