"where": "id is not null",
The issue happens only when the field 'location' is included to fields. The response we get is as below:
"errorMessage":"javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query",
We need a general solution for this, we can't go and hard code stuff, to not include the 'location' in the fields, or for other issues the API may have.
The location field is of type 'TO_ONE', but also the 'owner' field is of type 'TO_ONE' and that works just fine.