I can't imagine it takes more than a few circuits of water through the bore to recover all of the energy, the static column of water alone would contain a non-trivial fraction of the energy required to drill the bore after equilibrating.