Again, students who are attending schools outside the US are not expected to fulfill US HS requirements. As an example, students in the UK doing A-levels would never be able to meet the usual expectations, yet even tippy top US colleges happily accept them.
And, fwiw Columbia does not actually require 3 years of a foreign language, even for US-based students. I know, conventional wisdom says “highly recommend” is the same as “required” but it’s not. That’s where context comes in.