Select Code to Download

$schema->resultset('foo')->search_literal('EXCEPT SELECT * FROM bar')

SELECT * FROM foo WHERE ( EXCEPT SELECT * FROM BAR )

$schema->resultset('items')->search({'mapping.container_id' => 1}, {jo
+in => 'mapping'});

SELECT * FROM items LEFT JOIN mapping ON (items.item_id = mapping.item
+_id) WHERE mapping.container_id = 1

SELECT items.item_id FROM items LEFT JOIN mapping ON (items.item_id = 
+mapping.item_id) 
  EXCEPT SELECT items.item_id FROM items LEFT JOIN mapping ON (items.i
+tem_id = mapping.item_id) WHERE mapping.container_id = 1