Yes, I know I can run: DBSession.query(SomeModel).from_statement(SOME_SQL_QUERY).all()
As long as SOME_SQL_QUERY returns columns within the table associated with SomeModel. But a lot of times we need to run a more complex queries that returns results that spans multiple database tables. Back in TG1, using SQLObject, I can run such queries and get the correct results, but in SQLAlchemy, there seems to be no way to do this. Am I using the wrong object (DBSession), is there a way to just get a Session object from within TG2? Thanks, Will --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
