I know DI column from molecular biology labs. They are used as a pre-filtration before the water goes into a distilling unit. They are cylinders of various sizes/capacity with filled with ion-exchange resin. Water goes in at one end, out the other.
Pros: no waste water, no limit on short-term demand.
Cons: filter quality declines with time, and has to be replaced/exchanged after a while.