[Dbix-class] custom result source calling a stored procedure

[Mitchell Elutovich]

For a customer result source, I know we can do something such as:

$new_source->name( \<<SQL );
  ( SELECT u.* FROM user u
  INNER JOIN user_friends f ON u.id = f.user_id
  WHERE f.friend_user_id = ?
  UNION
  SELECT u.* FROM user u
  INNER JOIN user_friends f ON u.id = f.friend_user_id
  WHERE f.user_id = ? )
  SQL

is there any restrictions on the SQL; is it possible to have the SQL just
be a call to a stored procedure?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20140610/e9a5c44c/attachment.htm>