Catalyzes the conversion of 5-oxopentanoate (glutarate semialdehyde) to glutarate. Involved in L-lysine degradation. 5-oxopentanoate + H2O + NADP(+) = glutarate + 2 H(+) + NADPH Amino-acid degradation. Belongs to the aldehyde dehydrogenase family.