compile_query fails with sqlalchemy 1.4

[trvrmcs]

compile_query fails with sqlalchemy 1.4

[ods]

Just for the record. Native async support SQLAlchemy has some problems. And the most of them probably will never be fixed. The most notable is the lack of auto-commit mode, and wrapping each select into async with db.begin(): is really annoying. Also it has issues with pgbouncer.

[nhumrich]

I am actually thinking of deprecating this library now that sqlalchemy supports asyncpg directly. I already migrated an application too it, and might provide a migration guide.

[dyens]

For some new projects maybe a good choice to use async support of sqlalchemy

asyncio extension in sqlalchemy

I am thinking about this transition. I think it would be good to have some benchmarks for this..

[trvrmcs]

A migration guide would be helpful - I've built a number of projects on top of asyncpg over the years. Thank you for all your work in creating it, maintaining it, and being so responsive to my questions. (You helped me with a JSON encoding issue at PyCon a few years ago, if I recall correctly.)

[nagyt2]

+1 for the migration guide.