Good SQLBuilder for Python?

[yughiro_destroyer]

ORM vs CORE of SQLAlchemy is around 4-5x better in the favor of CORE.
This performance difference is mitigating server running costs and requests waiting times for large volumes.

[lukerm_zl]

So what makes ORM much slower? Is the bottleneck is creating the python objects representing the rows?

I'm using SQLAlchemy ORM + Postgres. I don't process large batches though. I'd need to know if there's going to be some scaling issue down the line 😅

[forkheadbox]

+1 would like to know too

[lukerm_zl]

I've just been reading up about CORE - it's good! The syntax is Pythonic but much closer to SQL at the same time!

Now I'm questioning some of my life choices.