but is connected to a long (horizontal) hose, then the flow speed will dimish, even eventually diminishes to zero as the hose is extended.
If the wall of the tank is of finite thickness, and the opening radius is smaller than the wall thickness, then the hole is like a hose. The speed of the out flow depends on the hole size.
This is because there is some friction within the water.