Honestly, instead of an "API" or some sort of HTTP RPC thing or even a RESTful interface, I just want a database that I can query. Seriously, just let me load my data and be on my way. Everything else is friction and pain points.