Re: [sqlalchemy] MSSQL ProgrammingError with aggregate functions

2016-02-24 Thread Alex Lowe
eft_string'), different_column]).alias() q4 = sqlalchemy.select([q3.c.left_string, func.sum(q3.c.different_column)]).group_by(q3.c.left_string) sql_engine.execute(q4).fetchall() On Wednesday, 24 February 2016 09:26:59 UTC-6, Mike Bayer wrote: > > > > On 02/24/2016 10:13 AM, Ale

[sqlalchemy] MSSQL ProgrammingError with aggregate functions

2016-02-24 Thread Alex Lowe
Hi there, I'm receiving a ProgrammingError with certain types of query to MSSQL (they seem to work fine when querying SQLite though). Either my Google-fu is weak or there hasn't been a solution posted publicly, since the two most useful-looking pages were these two StackOverflow threads with no