[Pumps] work well with windmills, and they can raise a fluid a reasonable distance. (More vertical distance means more energy required, of course.) They can pressurize a fluid to put a head on it. They work well with viscous fluids and fluids containing solid particles.
I would definitely like to be able to build one out of, say, a pipe section, two mechanisms representing the valves, a mechanism representing the piston and cylinder, and maybe a piece of leather representing the gaskets needed to prevent leaks.
Am I missing something? You
can build such a pump out of a pipe section, a single mechanism, and a block (no need for more mechanisms, or leather for gasket) and you
can make it windmill powered with a one or more mechanisms and some freshly felled wood... And all that can handle both water (purifying it of sediment without clogging up!) and magma, with very little need to overcome mechanical inefficiency until you displace the power quite a long way from the pump, relatively...
What I think you're still after (as with others) is the
piping of the liquid straight from the pump (and/or possibly pumps that can be made to pressurise, as well as/instead of somehow negating all incoming pressure). Pumps aren't the problem. Unless you actually want them more realistic. Although a double-throw cylinder-based system with one-way valves
can effectively remove all incoming pressure (that it can stand against, leastwise) and be made to only operate while pressure gauges indicate a single level still needs filling from its outflow.