my @requests = $schema->resultset( 'TblRequests' )->search({
                              'p.LastName' => 'Smith',
                              'p.FirstName' => 'John' },
                { prefetch => 'p' }
        );

foreach my $request (@requests) {
    print "Name: " . $request->p->LastName . ", ". $request->p->FirstName . "\n";
    print "SternID: " . $request->p->username . "\n";
    print "Status: " . $request->status . " . "\n";
}