Oh of course, and the sheer quantity of water to surface area in say a lake or other life-supporting environment is completely unpracticable - not to mention constant water renewal in moving waters - in a closed aquarium environment.
Over the past few months, I have been keeping a java fern in a 2.5 gallon tank with no substrate. The only inhabitants are a few red ramshorn snails (which are tiny) and a few malaysian trumpet snails (one of which has become quite the monster). No filter, no airpump, no feeding, no lighting, no substrate, nothing. Just water, a plant and some snails. Only thing I do is that sometimes I will change a bit of the water to old water from one of my tanks. And over the months, as a leaves die, they are broken down into detritus that has slowly been covering the bottom of the tank. Very slowly. Of course, were I to add leaves and a small piece of wood, that would accelerate the process, I am sure, also adding a diversity of matter to it. When I disturb the water, the stuff blows everywhere. The next day, of course, it is all settled. And, remarkably, the leaves of the plant are always clean. I am sure that the snails help with that as they move around.
I have been waiting for the tank to start to fill up with some kind of little critters and bestioles. But none have come along. I was really hoping for a couple of daphnia or copepods to start bopping around in there. May have to buy some and see how they do.