Quantum simulations of hydrodynamics via the Madelung transformation