Sand seems to drop like sand would, in piles that can be easily eroded away by both wind and water.
The water itself seems a little flaky at first and more viscous like milk, but keep in mind that the "elements" used are to create a puzzle, and water is really hard to accurately duplicate in any game. Though the way it "paves" rivers through sand makes you have to think more about how best to redirect it than just get rid of it, which I love.
The lava seems to work best either when dropped suddenly all at once or in small drips, because if you just pour it in a stream, it tends to build into a pillar, which is great for blocking things, but not always best if your villagers need to access an area beyond it.
I'm looking forward to timer cheats for the objectives as well as the god abilities, and perhaps a way to use the god abilities before earning them, I think if you add an infinite grab cheat it could work more to disadvantage as it could be glitchy and takes away the slight resource management aspect. Just my own personal view, to be honest, I can't wait for the trainer, no matter which options, I think it will make it more of a true "sandbox" game at times, and I can always play it for its puzzle-solving value without cheats.