Apparently it's not possible using SQLRestriction.
For your case @Filter & @FilterDef seem to be the way to go wich you can disable using the entity manager.
There is an article describing the exact use case. To access soft deleted data for e.g administrative purposes.