You might want to try select([col1, col2, col3]).select_from("scntest AS OF SCN 123") , though that won't integrate with session.query() unless you use from_statement().
I haven't seen that syntax before but it would otherwise have to be added to the oracle dialect as a feature, such as select(...., oracle_flashback="SCN 123"). I dont know what "AS OF" does but is it a syntactical substitute for standard SQL ? I'd go with the standard SQL if possible. On Jan 26, 2009, at 12:57 AM, botz wrote: > > Hi, > I'm wondering if there's a way I can add a string to the tablename in > a select query without affecting reflection, aliases, etc. > > Eg. > given: > > t = Table( 'c1', column( 'c1', Integer, primary_key=True) > > I'd like to be able to generate: > > SELECT scntest.c1 AS scntest_c1 FROM scntest AS OF SCN 123 > > maybe using something like > > session.query( t.from_append( "AS OF SCN 123" )).all() > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---