queryapitools

This extension helps you creating custom API's that retrieve query result data. If an external application needs information from CiviCRM that cannot be expressed using API parameters, you can use this extension. It allows you to create a custom API that returns data from an SQL query, in a way that you can use API filters, options and joining as always.

For more information, see the project page on github.