Filters: mechanical and electro adsorption
Long story short, I was looking at water filters and stumbled upon Grayl; they offer a limited capacity water filter that removes bacteria and viruses. They use a filtration methodology called electro adsorption. Basically, they use a passive charged surface to attract and trap bacteria and viruses. Since it is a trap, the lifespan is finite and rather low. Backflushing will get rid of sediments but will do nothing to remove the trapped bacteria or viruses.
A new company called Oassay (no affiliation), has a similar product but it looks like you can buy a replacement filter for $25. If they would just make an inline filter, this could be an inexpensive and effective drip filtration system for limited water volume (like 500 l).
https://oassay.com/collections/all-products
Below is what AI says about comparing mechanical filtration to electro adsorption.  Note: they say while it can be effective, it is highly dependent on the design implementation and lab results.



