migrate code from aiopg to asyncpg

[sanderegg]

sqlalchemy 1.4.xx and also sqlalchemy 2.0 contains now a full asynchronous engine to access databases.
it is based on asyncpg instead of aiopg.

SEE https://docs.sqlalchemy.org/en/20/orm/extensions/asyncio.html#synopsis-core

we shall first migrate the services, and then remove the aiopg-based code in the packages once it is unused.

Services

• catalog
• resource usage tracker
• storage
• web-server (in progress)
• api-server
• director-v2
• convert simcore-sdk aiopg --> asyncpg #7360
• service-library
• postgres-database
• efs-guardian (in progress)
• payments
• Evaluate hanging issue with tests. see https://github.com/itisfoundation/osparc-simcore/blob/b225239f987d1af08bce960fd553eab4b6605090/packages/pytest-simcore/src/pytest_simcore/helpers/postgres_tools.py#L20-L33

Tasks

• Refactor fixtures for Postgres DB testing