If you set:

<property name="hibernate.batch_fetch_style" value="PADDED"/>

it seems to generate the right SQL. Something with the LEGACY (Default setting).