Refactor result processing code into separate states

Some of the code in the backend protocol that tracks the result state checks for various special commands that can be detected at the start of the query. Separating out these special cases into their own states would shrink the amount of code that needs to be executed in the normal case.