announcement Exciting news!! Our new SQL API endpoint is launched.
This replaces any prototype DSLv2 endpoints and is production-ready.  
Please contact sales if you'd like to subscribe to it (it's not currently included in retail packages)

You'll be able to:

• Use SQL-like language to query our database in a very convenient and fast way.
• Enjoy swift response times, with multiple fields to query our entire dataset (often under 50ms).
• Obtain a JSON-formatted response for you to parse, transform and enhance the data.
• Shape your query using our SurfaceBrowser SQL Explorer and use it in the API.

Check these links for documentation, and a full reference or properties and operators.