Just go to English Bay on a sunny day and open a beer in the sand and see. Alcohol is prohibited there again since several months ago and being actively enforced.
I lived on Chilco & Nelson for many years... people simply have Starbucks cups with beer inside or other equivalent methodology of "wink wink". As long as you aren't being an ass there's zero problem..