My take is that it makes sense to grow the water-heavy vegetables yourself. These vegetables seem to be the most prone to damage during transport anyway. Plus, you can select heirloom varieties.

Then just get your staples (grains, potatoes, dairy products), plus fruits which require specialised agriculture, via the commercial food system.

If I had a house, instead of an apartment, I'd test the soil and then replace most of the backyard plants with good-looking and low-maintenance food producers; and replace the front lawn with pollinator-attracting xeriscape and maybe some herbs.