Thank you Mike Bayer for your help..
On Wednesday, June 27, 2018 at 8:32:18 PM UTC+5:30, Mike Bayer wrote: > > On Wed, Jun 27, 2018 at 3:22 AM, arjun k <arju...@gmail.com <javascript:>> > wrote: > > Hi > > i was trying to convert the below query to sqlalchemy > > > > > > SELECT > > addr_idn, > > (SELECT MAX(LastUpdateDate) > > FROM (VALUES (crt_dt),(upd_dt),) AS UpdateDate(LastUpdateDate)) > > AS LastUpdateDate > > FROM ( > > select a. addr_idn,a.crt_dt crt_dt , b.upd_dt upd_dt > > from emp_addr > > where emp_addr.addr_idn = 1 > > ) a > > > > > > > > but i am not able to convert this into sqlalchemy. please help me out to > > convert this query. > > > the hard part here is the "FROM VALUES" which is not built-in to > SQLAlchemy. There is a recipe at > https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/PGValues > that will show how to build a "values()" function that will give you > the VALUES() expression you're looking for. > > > > > -- > > SQLAlchemy - > > The Python SQL Toolkit and Object Relational Mapper > > > > http://www.sqlalchemy.org/ > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > description. > > --- > > You received this message because you are subscribed to the Google > Groups > > "sqlalchemy" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to sqlalchemy+...@googlegroups.com <javascript:>. > > To post to this group, send email to sqlal...@googlegroups.com > <javascript:>. > > Visit this group at https://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.