For optimal performance, yes use aiopg or equivalent (it looks like there is an asyncio sqlalchemy project which might be nice.)

Any middleware may be a coroutine object, so it's as easy as `await res.render("whatever")` in an async function