I've heard it also depends on the type of sand. Sandbox sand is
not what you want. You need sharp builder's sand. I would also say you need OM as well.
Adding sand to clay soil works if
A) You're adding the correct sand in the correct amount and using additional organic material.
B) you're in a small area. Not something to do above 100-200 square meters. When it's over a truckload or two, you
should adopt other strategies.
C) you don't mind doing the same thing after a few years. The effect of the sand is limited in time.
From my experience with clay soil, there is no one-time silver bullet that fixes everything. You have to constantly manage it to get good growing soil via mineral amendments, organic material, and possibly tilling/hoeing. That is, unless you're adapting the species to the soil. The geological and climatic conditions that gave you clay soil in the first places are not going away because somebody throws something into the mix, in this case sand.
As an aside, I'm currently using sand as an ingredient in a potting mix and it looks like it seems to be working well. Adding compost and leaf mulch.
William