Quickbooks Online has the following OCNQL limitations:
- OR operator is not supported in where clauses;
- GROUP BY and JOIN operator are not supported;
- Wildcard character support with LIKE clauses is limited to “%” (wildcard that substitutes for 0 or more characters);
- The response set returns all properties for each object (that is, projections are not supported).