When doing an entity join on an entity type that involves multiple tables, currently the joins for the subclasses are missing in the SQL leading to a syntax error when e.g. using a sub- or super-type property with joined inheritance strategy.
Take the following model
and the following query
The column for the property price is rendered in the ON clause into SQL, but the table join for the super type table item is missing.