BTW, I wonder *why* SQL engineers failed to expose the functionality in
a better way: couldn't a SQL engine easily consider the following
SELECT a,b,c FROM selectable_procedure(:x, :y, :z)
exactly equivalent to
SELECT a,b,c FROM selectable_procedure
WHERE param_x = :x
AND param_y = :y
AND param_z = :z
effectively hiding the fact that "selectable_procedure" is an SP instead
of a traditional table?
I don't think that would be better at all. It implies that x, y, and z are all optional parameters, which usually isn't the case.
--
Jonathan Ellis
http://spyced.blogspot.com
_______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
