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