4 ms·
I think this is really neat. It’s seems a bit more flexible than the composition approach of SQLAlchemy, too. I also like that the unit of composition is the C
by dfee 6y ago
I think this is really neat. It’s seems a bit more flexible than the composition approach of SQLAlchemy, too.
I also like that the unit of composition is the CTE.
- BiteCode_dev 6y agoCan you say more about that? I though SQLAlchemy core goal was exactly that. When does it fails, compared to Csql?
- akdor1154 6y agoMy desire was to be able write real SQL directly in the dialect of my database. SQLAlchemy can't give me that, instead I'd need to learn a special SQLAlchemy-specific query builder syntax that probably won't support all the analytical functions I want to use anyway. It's really a whole different beast to csql.
- BiteCode_dev 6y agoFrom what I understand, not only SQLA API does provide support for all functions you wish to use, but it provides also raw SQL escape hatch. What kind of limitations did you encounter in the past?