You feel more confident after drinking a few bears because alcohol lowers your inhibitions.
However, you are absolutely right about wanting to find a way to attract women while sober.
If you keep relying on something external like alcohol to help you meet girls, you eventually become completely reliant on it. And it makes you worse and worse when it comes to doing all that stuff while sober. In other words, it worsens your baseline ability.
You can achieve this same state of confidence while sober by taking advantage of social momentum.
60 Years of Challenge talks more about Social Momentum and Microavoidance in his material, but here's the jist of it:
Try to act on your small impulses as much as possible. For example, if you get a sudden impulse to give a dollar to a homeless person, do it without hesitation. If you get a sudden impulse to compliment a stranger while walking past them, do it without hesitation. If you get a sudden impulse to high-five somebody, do it without hesitation.
The more you act on your smaller impulses, the easier it will become to do "bigger" things like talking to a hot girl.
Practice social momentum enough and you'll never need liquid courage to pick up girls ever again.