Nested session.query using sqlalchemy

Asked Mar 27 '21 at 18:41

Active Mar 27 '21 at 18:41

Viewed 101 times

I am completely new in SQL Alchemy. I am trying to convert below sql into sql alchemy but not getting desire result. My query:

select   locationkey
,(select geo.value from locations__geo_coordinates geo where l._id=geo._sdc_source_key__id and geo._sdc_level_0_id=0) as latitude
,(select geo.value from locations__geo_coordinates geo where l._id=geo._sdc_source_key__id and geo._sdc_level_0_id=1) as longitude 
from locations l

I am trying to get result by using session.query(. Whatever I found is on SELECT but that also giving error.

asked Mar 27 '21 at 18:41

user2493287

You should provide more information, maybe share your model definitions. – van Mar 27 '21 at 20:58
Perhaps this will be helpful: https://stackoverflow.com/a/43655840/6560549 – SuperShoot Mar 28 '21 at 09:45
@SuperShoot Thnaks. It helped me. – user2493287 Mar 30 '21 at 10:00

Nested session.query using sqlalchemy

0 Answers0