> My (limited) understanding is that conventional reverse osmosis is not far from the theoretical optimum, energy-wise, the main difficulties being operational (the membranes need declogging). And of course RO is more expensive than rain.

RO is about 2-4x the theoretical minimum, depending on how much water you're willing to reject.