Based on the future of the fortress thread talking about aquifers. The point came up that even thought aquifers are pierceble, they are a little obnoxious to deal with. Let's talk about what would need to be done to make them a little less fiddly and capable of murdering all your miners. As well as all other aquifer suggestions you may have.
I tried doing my research, and there's been very little mention on improving aquifers before:
The Underground Diversity Thread suggests aquifers that generate water slower, as well as a mini aquifer: a spring.
The cooking mega thread suggest we should use aquifers as a high-quality water source.
The watery diversity thread doesn't have much more than aquifers contributing to
Soil Liquifaction and hot springs.
Research on aquifers themselves shows that generally aquifers are removed... by mining them. Obviously, because aquifer water is quite high quality drinking water, and real life aquifers are finite. Within Dwarf Fortress however, the main cause of aquifers being so tricky is that dwarves refuse to build on semi-wet tiles, something that is sensible on unsensible depending on how you think dwarves make their walls non-porous(sensible would be by using concrete and mortar, that would not be possible in semi-flooded tiles, but unsensible might be a dwarvish ability to cut stone that tightly.)
So my suggestion is that either dwarves need to be able to build on semi-flooded tiles, or aquifers need to be finite in size, and preferably a necessity for a lot of alchohol.