Semi‐Nonlinear Nanophotonic Waveguides for Highly Efficient Second‐Harmonic Generation