any dropping of "AS" for alisases has to occur locally within the firebird dialect; most other databases require it. you can add an overridden "visit_alias()" method in firebird's FBCompiler (the base method is in ansisql.py) to achieve this. (feel free to send a patch. I have no test instance of firebird here).
On Oct 6, 2006, at 4:21 AM, Lele Gaifax wrote: > Ezio Vernacotola wrote: >> A possible workaround is switch to firebird 2.0 now, is very close to >> final release, largely backward compatible and accepts "AS" in table >> aliasing > > Unfortunately it's not an easy switch, so I gently insist SA should > drop > the "AS" keyword usage, even from the columns if that makes it an > easier > task. > > ciao, lele. > > ---------------------------------------------------------------------- > --- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > opinions on IT & business topics through brief surveys -- and earn > cash > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
