[SQLObject] Passthrough SQL.

[Ian S. <Ian...@et...>]

Before I start digging into the source code does the following ability =
already exist in SQLObject and, if not, does anyone else want it.

AFAIK SQLObject can't do complex joins. For instance, I might want to do =
a query like :

SELECT TimeOfRequests.* FROM TimeOffRequests INNER JOIN Users ON =
TimeOffRequests.cUserID =3D Users.cID WHERE Users.Dept =3D 12

The result will be a set of "A" objects so I'd like SO to treat them as =
such. So if SQLObject doesn't already support it what I'd like to be =
able to do is :

timeOffReqs =3D TimeOffRequests.get(passThrough=3D"SELECT TOR.* FROM =
TimeOffRequests TOR INNER JOIN Users U ON TOR.cUserID =3D U.cID WHERE =
U.Dept =3D 12")

Obviously, I've just broken the portability of my code so if there were =
a more SO-ish way of doing it I'd gladly take the education.=20

However, in some DB's like Firebird you can get SQL results from a =
StoredProc or a view or something and this pass-through capability could =
prove useful.

Thoughts?