>> “But how did this, with its need for flexible piping and wiring, ever get past the code bureaucrats? <<
.
Rotating plumbing and electrical fittings are not particularly unusual.
The great trick is to get them all concentric about the same axis--water, wastewater, power, gas, maybe telecom.
Telecom could I guess be left out by using wifi on the ground under the house or somewhere else nearby.