codeintel: Auto-inference sandbox - Unify require and loadfile

Created by: efritz

In order to get file-local imports to work I quickly reached for updating the hook for loadfile rather than adding it properly into the require machinery as pre-loaded modules.

This issue addressed this feedback.