There's a bunch of literature about accessing graphs through tree lenses. I'm not sure exactly what you're looking for.

SQL certainly forces you to look at graphs as trees. Do you have an specific interface you're trying to access? If you're trying to use a graph database, why mention APIs and SQL?