The Freebase API is a hosted service. MQL is designed for fast HTTP queries that power interactive webapps.

SPARQL is harder to learn and set up, but allows for more complicated queries that might require offline processing.

(I designed the first version of MQL)