Maybe somewhat counter-intuitively, vegetables & fruits like melons, watermelons, cucumbers, etc. (that contain a lot of water), often grow well in dry-looking sandy soil. I think it may be partly because the soil is loose, so their roots can go deeper more easily, to reach the water below. As a result, I've often seen and heard of these plants growing or being grown near rivers and lakes, even somewhat far away from the water's edge, because there is water below, in the water table.

Source: I did a lot of gardening in my teens and also read a lot about it.