I don't know a lot about DBIx::Class, but you can write the query using something like:

SELECT * FROM items 
WHERE item_id NOT IN 
     (SELECT item_id FROM mapping 
      WHERE container_id = ?)
[download]

It looks like you can shoehorn that WHERE clause into the search_literal method the way you need to.