XX $ % pip install --user  pymssql
Looking in indexes: http://pypi.douban.com/simple/
Collecting pymssql
  Downloading http://pypi.doubanio.com/packages/25/f4/7a8f70edbfdc4de0f72ba44611b6ed6c175a1b2b1ce22051af0e8a8111c1/pymssql-2.2.2.tar.gz (170 kB)
     |████████████████████████████████| 170 kB 9.9 MB/s            
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: pymssql
  WARNING: Building wheel for pymssql failed: [Errno 13] Permission denied: '/Users/carl/Library/Caches/pip/wheels/b2'
Failed to build pymssql
ERROR: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects


XX $ % sudo pip install pymssql
WARNING: The directory '/Users/carl/Library/Caches/pip' or its parent directory is not owned or is not writable by the current user. The cache has been disabled. Check the permissions and owner of that directory. If executing pip with sudo, you should use sudo's -H flag.
Looking in indexes: http://pypi.douban.com/simple/
Collecting pymssql
  Downloading http://pypi.doubanio.com/packages/25/f4/7a8f70edbfdc4de0f72ba44611b6ed6c175a1b2b1ce22051af0e8a8111c1/pymssql-2.2.2.tar.gz (170 kB)
     |████████████████████████████████| 170 kB 8.5 MB/s            
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: pymssql
  Building wheel for pymssql (pyproject.toml) ... done
  Created wheel for pymssql: filename=pymssql-2.2.2-cp39-cp39-macosx_11_0_arm64.whl size=250081 sha256=2abb6c571913ea8bc59b6b844076ddd668c02f5c948a1282e20c138ab74f4e91
  Stored in directory: /private/tmp/pip-ephem-wheel-cache-edr0lbz2/wheels/b2/33/23/822bd89d7a0becd0316a343850171a2b913b9a33f26203ec6d
Successfully built pymssql
Installing collected packages: pymssql
Successfully installed pymssql-2.2.2
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv