That’s the issue - this isn’t an engineering problem, it’s a general consumer problem. It’s what focus groups full of regular people are for.
The primary users of any API are the designers and engineers of the applications that use it. How many laypeople know what Postgresql is? How many of the applications they use run on it?