Direct-drive on solar for daytime water or if SHTF and the grid goes down for good. Solar pumps can often be run in hybrid mode if AC power is available.
Often paired with solar to keep batteries recharged, or use the grid to charge batteries and keep maintained for power outages. Or do both.
Traditional well pump option designed for grid/utility power (or 220v generator)