Hi, Firebird 1.5 allows the following sentences:
select myfield from mytable; select myfield FOO from my table; select myfield AS FOO from mytable; (the last 2 sentences change the name of the final column, right ?) The same rules don't apply when we create tables aliases: select myfield from mytable BAR; => this works select myfield from mytable AS BAR; => this doesn't work Is there any way to make SA avoid to use this " as " sintaxe when aliasing table names ? I am trying to use 2 mapped objects, with relation(..., lazy=False), and I am getting FB's error: "Token unknown" just because " as " is been used in the SQL generated by SA... :( BTW, I have also tried do use quote=False in Table() declaration, but it seems to not have any influence... am I missing something ? Please let me know if you need more details... Cheers, Roger ------------------------------------------------------------------------- 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
