Take the tour ×  Using DBIx::Class and I have a resultset which
needs to be filtered by data which cannot be generated by SQL.
What I need to do is something effectively equivalent to this
hypothetical example:  my $resultset     =
$schema->resultset('Service')->search(\%search); my
$new_resultset = $resultset->filter( sub {     my $web_service =
shift;     return $web_service->is_available; } );  Reading
through the docs gives me no clue how to accomplish a strategy
like this.  share|improve this question add comment  2 Answers
up vote 8 down vote accepted  You can’t really, due to the goals
for which DBIC result sets are designed:    • They compile down
to SQL and run a single query, which they do no earlier than
when you ask for results.   • They are composable.  Allowing
filtering by code that runs on the Perl side would make it
extremely hairy to achieve those properties, and would hide the
fact that such result sets actually run N queries when composed.
Why do you want this, anyway? Why is simply retr