If you look at the data for SF, 95% of brand new units are first occupied by people who have lived here for a at least a few years. New housing serves people who are already here.
What causes people to migrate to the bay is the office creation, not the housing creation.