Growing up in a village, we did this sometimes near a pond. Instead of sand, it was soft clay. It was fun to see it fill up with water when it got deep enough.