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.
The condition on numexpr is may be too strong, may be we should do the trick only for unhashable results and when using numexpr ? Hello @AlexisMignon! Thanks for updating this PR. We checked the lines you've touched for [PEP 8](https://www.python.org/dev/peps/pep-0008) issues, and found:





There are currently no PEP 8 issues detected in this Pull Request. Cheers! :beers: 

##### Comment last updated at 2021-09-24 08:09:00 UTC very nice @AlexisMignon thanks!