Optimization - order only on lazy prefetch

If the user wants all() without an order_by she doesn't care anyway
Reintroduce conditional null-branch pruning and add direct-to-HRI option

<massive commit message yet to come>