SQL error when loading multiple associations with the same name

Another solution is changing the name of the "Posts hasOne Revisions" Asociation, like

$this->hasOne('LatestRevision', [
    // ...
    'className' => 'Revisions',
]);
TableRegistry::get('Users')->loadInto($user, ['Revisions.Posts.LatestRevision']);