Explanation
The format that the custom Salesforce relationship with the API name,
My_Relationship_Name__r.My_Name__c is queried and transformed into by default in Salesforce B2B Commerce is myRelationshipName.myName: value. This is done to follow the JavaScript naming convention and to avoid conflicts with the standard Salesforce fields and relationships. The transformation rules are as follows:
* Remove any namespace prefix from the field name, such as ccrz__ or cloudcraze__.
* Remove any underscores from the field name and capitalize the first letter of each word after an underscore, such as MyRelationshipName and MyName.
* Lowercase the first letter of the field name, such as myRelationshipName and myName.
* Use a dot (.) to separate the relationship name and the field name, such as myRelationshipName.myName.
* Use a colon (:) to separate the field name and the field value, such as myRelationshipName.myName:
value. Salesforce References: B2B Commerce and D2C Commerce Developer Guide, Query Transformation