Engineering biology for sustainable bioproduction from CO₂