Shallow well piston pump