my $artistsAndTitles = $schema->resultset('Artist')->
   search(...)->search_related_rs('cds', {...})->as_data

# or another case using a accessor-method with the name 'cds' from a many_to_many relation:

my $artistsAndTitles = $schema->resultset('Artist')->
   cds()->as_data ;