what I'd like is for the whole "AS foo" block to be executed atomically on server2, so that the only thing received by server1 is a resultset containing 3 numbers:
This is very easy.
Create views in server2 and in server3 and use the views in the code.

Tamil