Garden hose is a bit different. Bacteria can get in through the hoses open end, and it’s really hard to completely dry out the inside, so it’s just a microbe fest inside there. The issue isn’t so much the plumbing, straight from the spigot is… Well, still a bit worse because it’s outside but should be ok. It’s the hose that’s the problem. Beyond that, yeah water in any tap inside should be essentially the same, barring filters after the plumbing.

Edit: just thought, some houses may use a grey water recycling system for, say, running the toilet and shower. I imagine that’s rare enough that if it applies to you, you probably already know, but… Well, ya know.