Re: [sqlalchemy] Selects, Outer Joins, and Auto-Correlation

2018-11-12 Thread andrew cooke
Thank-you! I am sure that will be right - I was trying to find a "from" in the docs, but missed the select_from(). Thanks again, Andrew On Mon, Nov 12, 2018 at 10:15:05AM -0500, Mike Bayer wrote: > On Mon, Nov 12, 2018 at 10:07 AM Mike Bayer wrote: > > > > On Mon, Nov 12, 2018 at 7:56 AM

Re: [sqlalchemy] Selects, Outer Joins, and Auto-Correlation

2018-11-12 Thread Mike Bayer
On Mon, Nov 12, 2018 at 10:07 AM Mike Bayer wrote: > > On Mon, Nov 12, 2018 at 7:56 AM andrew cooke wrote: > > > > > > I have some code that uses high-level ORM and it works fine, except that > > one particular section is too slow. So I was trying to replace that > > section with a lower

Re: [sqlalchemy] Selects, Outer Joins, and Auto-Correlation

2018-11-12 Thread Mike Bayer
On Mon, Nov 12, 2018 at 7:56 AM andrew cooke wrote: > > > I have some code that uses high-level ORM and it works fine, except that one > particular section is too slow. So I was trying to replace that section with > a lower level query. But I can't work out how to persuade the Expression >

[sqlalchemy] Selects, Outer Joins, and Auto-Correlation

2018-11-12 Thread andrew cooke
I have some code that uses high-level ORM and it works fine, except that one particular section is too slow. So I was trying to replace that section with a lower level query. But I can't work out how to persuade the Expression Language to stop auto-correlation. The query I am trying to