The following AnnotationMapping throws a MappingException ...

Unable to find column with logical name: id in org.hibernate.mapping.Table(template) and its related supertables and secondary tables

@ManyToOne
@JoinColumnsOrFormulas({
   @JoinColumnOrFormula(column = @JoinColumn(name = "template", referencedColumnName = "id")),
   @JoinColumnOrFormula(formula = @JoinFormula(value = "'custom'", referencedColumnName = "type"))
})

This is caused by identifying the column names within the logicalToPhysical map of TableColumnNameBinding. Within this map the column names are surrounded by grave accents (`id`) while the check do a lookup to the map with plain column name (id).

A workaround for this issue is surrounding the column name with gave accents.

@ManyToOne
@JoinColumnsOrFormulas({
   @JoinColumnOrFormula(column = @JoinColumn(name = "template", referencedColumnName = "`id`")),
   @JoinColumnOrFormula(formula = @JoinFormula(value = "'custom'", referencedColumnName = "`type`"))
})