public MyEntity {

    @ElementCollection(fetch = FetchType.LAZY)
    @CollectionTable(name = "my_entity_name_lv", joinColumns = @JoinColumn(name = "my_entity_pk"), indexes = { @Index(columnList = "my_entity_pk") })
    @MapKeyColumn(name = "locale")
   private Map<Locale, LocalizedValue> name;
}

@Embeddable
public class LocalizedValue implements Localized {

    /**
     * Default serial version uid.
     */
    private static final long serialVersionUID = 1L;

    @Column(name = "value")
    private String value;

select p from my_entity as p join p.name as n where :name in (VALUE(n))

HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query ...

select p
from my_entity p
where :name in elements(p.name)

JPAQuery query = new JPAQuery(this.getEntityManager());
QCampaignEntity qCampaign = QCampaignEntity.campaignEntity;
QCampaignVersion qCampaignVersion = QCampaignVersion.campaignVersion;

BooleanBuilder builder = new BooleanBuilder();
builder.and(qCampaignVersion.introducers.contains(introducer));
builder.and(qCampaignVersion.brandings.contains(branding));

List<CampaignEntity> res = query
      .from(qCampaign)
      .innerJoin(qCampaign.activeVersion, qCampaignVersion)
      .where(builder)
      .list(qCampaign);

select campaignEntity
from CampaignEntity campaignEntity
inner join campaignEntity.activeVersion as campaignVersion
where ?1 in elements(campaignVersion.introducers) and
         ?1 in elements(campaignVersion.brandings)