On May 11, 2007, at 2:39 PM, Paul Johnston wrote:
> > Hi, > >> Both queries are complaining because MSSQL insists that all derived >> tables (that is, subselects used as tables) be aliased with an "AS >> xxxx" clause. > > Just so you know, providing a hack in MSSQLCompiler to do this > automatically is on my todo list. > the "AS xxxx" clause requirement is not just an MS-SQL requirement, other DB's have this issue too; and im not sure if i like the idea of having it happen automatically (since i think even MS-SQL has certain clauses where the subquery doesnt need an alias, like in an EXISTS or column-based subquery, and also i dont like the idea of making up an alias name). i understand the "remove order by from subqueries" hack but i think this one is more fundamental. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
