I am trying to track down a short story (possibly from a sci-fi or fantasy anthology) that I remember reading in the late 1980s/early 1990s, with a plot broadly similar to the classic story "Leiningen Versus the Ants", but it is not that story.
As I recall, the story begins with the point of view of an insect noting that it was time to move on because their food supplies were exhausted. Most of the story is then from the PoV of a family of farmers, who are alerted to the arrival of the swarm of insects when the daughter comes running in from the fields covered in insects, with the father having to almost drown the daughter to get rid of them.
I then remember the family desperately digging moats around their farmhouse using whatever tools available, even bare hands, until finally collapsing with exhaustion when they are done. But the insects manage to overwhelm the moats by using their drowned bodies as a bridge, and the story ends with the families corpses being picked to the bone.
Interesting, but what actually about this makes it sci-fi or fantasy? Like, were the insects bio-engineered, or anything like that? Did it have sci-fi or fantastical elements? Or were they "normal" insects?
The main thing I remember was that the insects appeared to be intelligent, because the opening scene was from their PoV. Other than that there was no explicit sci-fi or fantasy elements that I remember. But at that age I pretty much exclusively read sci-fi and fantasy, which is the main reason why I feel the story would have originated from that context.
...it's perhaps possible that the farmers were actually colonists on some alien planet, but again, if so, this setting was not made a major focus of the story.