The best "API language" is the one constructed to work with the app's data model. SQL constructs are relational - fine for rails, django, or salesforce apps which map screen to table (or table join).

Wouldn't work for facebook, google knowledge graph, or the larger enterprise app vendors today. Theirs is typed graph.