A versatile in situ cofactor enhancing system for meeting cellular demands for engineered metabolic pathways