Add flag to retreive deleted paranoid models in queries

Implementation as suggested in #1862
could you change all these `success` to `then`?
`then` is the correct method, `success` is just our BC method.