For longer drink, real ale, proper cider, wine. Or you could be boring and ask for water.
A real ale or proper cider shouldn't be particularly fizzy. A good cider should be almost indistinguishable from apple juice, at least until the point you fall off your seat.