Yes, you can substitute pineapple juice for water in cake. The flavor may be sweeter this way since pineapple juice has more sugar than water, but the pineapple juice will add a bright and tropical flavor and moisture to the cake.