With respect: a "huge offset" is simply the same as a "horizontal" pipe run. Clips secure the joins, and clips fix the stability of the pipe.
Occasionally, if no fixing can be found then pipe and fitting can be "glued" but, for my money, never screwed.