[2.0] Update DB integrations to use new scopes

[sentrivana]

Problem Statement

Some integrations are still using old APIs like hub cloning.

Solution Brainstorm

Update the following integrations from old-style (e.g. configure_scope) hubs&scopes API to the new scopes API.

• [ ] asyncpg
• [ ] clickhouse_driver
• [ ] pymongo
• [ ] redis
• [ ] rediscluster
• [ ] sqlalchemy