but I've only ever considered that friend in a sexual way in passing (the sort of "if she asked I'd be game" kinda thought) and so this feels very out in left field
Well, put it this way. I, at least, have never had s sex dream that I expected. The occurrence and partner that my brain supplies are a surprise every time.