Standard REST APIs are used to manipulate a single object whose resource identifier is known. The Query REST APIs allow for querying a collection of objects with SQL like capabilities. Each query APIs will document what properties may be used in the filter and sort portions of request.
Each query API targets a specific object type such as accounts, time entry, work orders, etc.
Query APIs do not support joins across other object types.
Any long running queries will automatically be canceled to prevent possible system degradation.