if you use a table with mixed case identifiers, quotes are required. additionally, SA's ORM queries use the "use_label=True" flag so that joins among many tables can be constructed without the issue of column names conflicting.
as for "too much work on the MySQL side", i can assure you that you'd hardly detect even a milliecond's difference in performance between quoted/labeled and non, even if you ran the query a million times in each style. the database is *definitely* where you want to put the most computation possible, compared to a Python script. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy -~----------~----~----~----~------~----~------~--~---