Three‐dimensional Lattice Boltzmann simulation of gas‐water transport in tight sandstone porous media: Influence of microscopic surface forces