I use my Python on my 20-gallon Lake Tanganyika tank, and the substrate is all black sand. It may depend on your water pressure; for me, the sand acts just like the gravel does when it's vacuumed... you know, stirring up about a third of the way up the python tube but no more.
The thing to watch out for when Python-ing sand is to make sure all the sand has floated back out of the tube before you lift it up to stop the suction. Otherwise it will go down your sink, which can mess up the pipes and/or garbage disposal.
The thing to watch out for when Python-ing sand is to make sure all the sand has floated back out of the tube before you lift it up to stop the suction. Otherwise it will go down your sink, which can mess up the pipes and/or garbage disposal.