I should add that this is not a DIY job. It will be hired out, as soon as I can figure out an option that's less nasty and somewhat affordable.
I do have other sources for plant water, though it's a pain. But it's do-able.
And if you're wondering how I ended up in a house with a flat roof in the first place,
the answer is "It's Complicated." Sigh.
Edit: If this was our forever house, I would dig deeper and rework the roof entirely. In 5 years, maybe 10, we may not be here.