It does but the dirty secret is that given enough money or interest zoning is a relatively weak opponent - there jus tidbit that much desire for mixed use buildings in most areas.
(The low-key method for normal people is to get “variances” - which are not as impossible to obtain as you may think if you work slowly and quietly on them.)
