[sqlalchemy] Re: How do I access a column that is the result of an outerjoined subquery?

2022-07-09 Thread Montana Burr
Or, is the query right? And if so, how do I get the "daily_calorie_sum_less_than_expected" column? On Saturday, July 9, 2022 at 2:12:35 PM UTC-6 Montana Burr wrote: > Hi folks! > > I have a rather complicated SQL query to perform. I kind of know how I > would do it in SQL and am looking to

[sqlalchemy] How do I access a column that is the result of an outerjoined subquery?

2022-07-09 Thread Montana Burr
Hi folks! I have a rather complicated SQL query to perform. I kind of know how I would do it in SQL and am looking to port it to SQLAlchemy. I have these ORM classes: class User(Base): __tablename__ = "Users" id = Column(Integer, primary_key=True) username = Column(String)