in reply to Combined SQL Queries (e.g., EXCEPT) and DBIx::Class

At first attempt, I can't even use search_literal because the string is stuffed into a WHERE clause:
$schema->resultset('foo')->search_literal('EXCEPT SELECT * FROM bar')
becomes something like
SELECT * FROM foo WHERE ( EXCEPT SELECT * FROM BAR )
What about:
$schema->resultset('foo')->search_literal( '1=1) EXCEPT (SELECT * FROM + bar' )
Just _might_ fall into the category of "Hack" though :)