Sand and gravel have been used for over a century to filter water for drinking. The dirty water to be filtered is usually applied to the top of the gravel for easy cleaning, because the deeper into the gravel bed it is applied, the easier it is for pockets of debris to collect and form mudballs (which are hard to get out, and can be nitrate factories).
Filters need to be backwashed evenly from the bottom up, to remove debris, our filters had pipes inlaid over the bottom to force water up, which forced debris out. Each filter needed to be backwashed every 4 days, or break threw of particulate would occur, and internal mud balls could form compromising efficiency.
Water had to be prefiltered before applying to the gravel beds to keep the gravel from clogging, which would require even more maintenance.
I was in charge of analyzing filter efficiency, and locating problem areas in each of 32 filters like the one in the pic below.
And find although they are great as part of a treatment chain for producing millions of gallons of drinking water, I would not use this method for my aquariums, as they are much more work to keep clean, and unless carefully monitored can create unexpected and unseen nitrate and bacterial pockets.
