We are trying to make a single SuiteQL query (through the REST API) to get multiple Customer records with their relevant Contacts and Addresses. If we made this query in the REST API directly, we would have to make an individual request to get every Customer record - which would be a very slow way to sync potentially thousands of records!

We have figured out - more-or-less by guessing - the table names to get Contacts with the customers with a JOIN like this:

SELECT c.id,c.companyName,c.phone,cn.firstName,cn.lastName,cn.title FROM customer as c JOIN contact as cn ON c.id = cn.company ORDER BY c.id ASC