Can a temporary visa lead to permanent residency?

In many cases, yes. Several temporary employer-sponsored visas offer a structured pathway to PR.