There must be a way to run something without needing a temp file...
echo -n "base64encodedelf" | base64 --decode | python3 -c 'import os;import sys;f=os.memfd_create(os.MFD_CLOEXEC);os.write(f,sys.stdin.buffer.read());os.execve(f,["dummy"],[])'The reason that running a binary needs a file is because execve() takes a path as an argument. But, as you said, there are other ways to load code into memory.
pipe(2) doesn't create a file, at least not in the sense that I usually think about files (something that's accessible through the filesystem).