Async run_transaction or aiopg and asyncpg

[tailhook]

Would be nice to have, and looks easy enough to implement.

Eventually, I'll probably implement one myself if nobody jumps in. Any hints for implementation?

[tailhook]

Also, it looks like transaction.py imports psycopg2 for no reason (just to catch error name), if I use asyncpg. So the the line:

from .transaction import run_transaction  # noqa

... should be removed. Or module itself should be made more robust.

[syncblaze]

Actually I would really like using run_transaction with asyncpg (or having a run_transcation function that supports async usage).

Is there anything new on this Topic? i will try building my own impl and make a PR if not.