Re: [sqlalchemy] Analogue of SQL view in SqlAlchemy

2017-01-21 Thread Stephen Davies
Thanks Mike. That approach is working well. On Sunday, 15 January 2017 03:48:19 UTC+11, Mike Bayer wrote: > > > > On 01/13/2017 11:13 PM, Stephen Davies wrote: > > (Using latest SqlAlchemy with either sqlite or postgres on a Flask > server) > > > > I h

[sqlalchemy] Analogue of SQL view in SqlAlchemy

2017-01-13 Thread Stephen Davies
(Using latest SqlAlchemy with either sqlite or postgres on a Flask server) I have a table of entities and stats with columns: id, date, stat1, stat2, etc. There are a lot of endpoints on the Flask server that need to do processing on an aggregated form of the above, something like: SELECT id,