Why does the LIKE SOQL operator implicitly translate picklist values?

This is what I think is the reason for the LIKE operator to automatically translate picklist values: The LIKE operator is used to match strings. The picklist value is translated, probably because of situations when the end-user searches for text in his own language.

Consider the following situation: a custom search component for a multinational company that supports many languages. The requirement is to enable search in picklist values that are being added/deactivated every month or so. If the user wants to search for a string, he won't type the API name of the field, but the translated version of the value he wants to get.

cheese translation picklists


I don't have a why for you, but if you have a scenario where LIKE needs to match the API name, you could create a formula field targeting the same picklist. FFs always return API name not label.