Transactions & Connection Pooling

[rs-ds]

We have to leverage, asyncpg's transaction & connection pooling

[rmad17]

From an architecture perspective I like how SQLAlchemy is designed. We probably do not need so much complexity as is present in SQLAlchemy however we can take some idea from how they implement it here.
One thing I especially like in SQLAlchemy from Django is how you can easily create connections manually/dynamically without forcing to be written to settings.