Using SuiteQL, is it possible to pull the contacts associated with a transaction?

AI generated answer (using internal Slack threads):

Based on the conversations, it is possible to pull the contacts associated with a transaction using SuiteQL. However, it's important to note that you may not be able to get the actual role besides the primary one. You can create a Contact search and use the Transaction join. Here is a SuiteScript 1.0 code example provided in the conversation:

javascript
var contactSearch = nlapiSearchRecord("contact",null,
[
   ["transaction.internalidnumber","equalto","8337"]
],
[
   new nlobjSearchColumn("entityid").setSort(false),
   new nlobjSearchColumn("email"),
   new nlobjSearchColumn("phone"),
   new nlobjSearchColumn("altphone"),
   new nlobjSearchColumn("fax"),
   new nlobjSearchColumn("company"),
   new nlobjSearchColumn("altemail"),
   new nlobjSearchColumn("internalid","transaction",null),
   new nlobjSearchColumn("tranid","transaction",null),
   new nlobjSearchColumn("recordtype","transaction",null),
   new nlobjSearchColumn("type","transaction",null)
]
);

This script creates a search on the Contact record and uses the Transaction join to filter the results based on the transaction's internal ID. The search columns include various contact and transaction fields. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

What would be the SQL statement?