Zuora Object Query Language - API Documentation

Zuora supports a simple SQL-like query language for use with the query call. A basic familiarity with SQL is needed in order to construct queries; therefore, that basic knowledge is assumed in the following discussions.

Syntax
The basic query syntax is:

select field_names from object

select field_names from object where filter_statements

Read more on Zuora Object Query Language - API Documentation