Re: [sqlalchemy] Extra table name in FROM clause

Here is SQL that works as expected: SELECT m.*, d.* FROM ( SELECT person_id, service_id, person_id_internal, meters_readings, -- two-dimensional array meters_readings [generate_subscripts(meters_readings, 1)] [1] AS meter_id, meters_readings

Re: [sqlalchemy] Extra table name in FROM clause

On Thu, Jan 4, 2018 at 4:08 PM, sector119 wrote: > Hello, > > In this query I get extra (unexpected) "databases" table name in FROM clause > > q = dbsession.query( > meter_readings.c.reading, > database.c.service_id > ). \ > select_from( >

[sqlalchemy] Extra table name in FROM clause

Hello, In this query I get extra (unexpected) "databases" table name in FROM clause q = dbsession.query( meter_readings.c.reading, database.c.service_id ). \ select_from( database.outerjoin(meter_readings, true()) ).filter(Database.person_id == person_id)