I have to disagree the modern and more efficient way to extract water from a borehole is by a submersable pump. We have used this on all boreholes we have used to extract water for heat pumps. Granted this is in the UK where we like to do things efficiently!