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, suchas 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