Refactor the ActiveContext Query Result class

Context

1. Add self.success and self.error methods

   From !208905 (comment 2829350875)

   suggestion (non-blocking): This reminded me of the ServiceResponse class in terms of implementation goals. I reviewed it to see if there is any inspiration to take from that class. Specifically I think having error and success methods might be helpful and I like the idea of adding support for logging/raising exceptions, but wanted to see what you think about it.

2. [Optional] refactor how success? method is written

   See discussion in !208905 (comment 2829350878)