Honestly I don't mind. A document API with a little manipulation on the front-end would be fine, as long as the back-end has some way of running through the relations.
A SQL-ish API might even be better, although I can see some pitfalls. Maybe base it on GraphQL as a compromise?