BUG: Solves errors when calling series methods in DataFrame.query with numexpr
- [x] closes #22435
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] whatsnew entry

The initial issue #22435 (check that there is no conflicting names failing) was actually hiding a deeper one leading to a failure when calling `numexpr.evaluate()`.

The commit proposed here solves both issues by adding a temporary variable to the scope for the results of function / method calls when using numexpr engine.