Re: [sqlalchemy] CTE w/VALUES in SELECT?

2022-02-20 Thread Mike Bayer
the Values construct doesn't have CTE direct support right now so you need to make a subquery first, then CTE from that from sqlalchemy import Column from sqlalchemy import column from sqlalchemy import Integer from sqlalchemy import select from sqlalchemy import String from sqlalchemy import

[sqlalchemy] Remove/Filter a query.all() results, add a 'virtual' column

2022-02-20 Thread Cp Divers
Hello Guys, this is my very first post here. I'm not sure this the the right place. I'm a week old with Python and SQLAlchemy. And I believe I'm missing a couple concept, hopefully you can help| I do have this class class BLPart(db.Model): __tablename__ = 'BL_parts' ITEMTYPE =