Yet another issue with a homebrew update => python upgrade => "No module named 'praw'" (missing site-packages)

I ran through a few upgrades of homebrew, in the past, and all python scripts I used to use were running fine, post python updates, meaning the upgrades got all necessary site-packages properly accounted for. Today my luck ended using the same mechanism: brew update && brew upgrade && brew cleanup --prune=all), and I see my new python version at 3.12.2 having replaced my previous 3.11, but missing tons of stuff in /usr/local/lib/python3.12/site-packages (as compared to 3.11). Some of them are the praw ones, thus the obvious "No module named 'praw'" when trying to run a python script dependent on it. I do recall having had a similar issue, a while ago, which I thought I fixed with some simple pip install --upgrade praw or python -m pip install --upgrade praw, but these are now coming back with the "error: externally-managed-environment". Any ideas how I could fix this?