hi i've no much idea about sql views, so i want to ask something. As i understand, views are sort-of virtual tables consisting of whatever a query structure may contain. So: 1) is it possible sql views to be created via SA in a more or less server-independent way? if issuing raw sql is the only way, any pointer how it is done in, say, sqlite, postgres, mssql? 2) once there, what can be done with them? are they a readonly "table"? can they have "foreign keys" i.e. relations to and from? 3) what is the advantage of a view vs issuing the ~same query over and over? i mean, if it's just faster, roughly how much - 2x, 10x, ..?
thanks svil --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---