Pymssql not working

I’ve set up a recorder with pymssql. Since the upgrade of Python to 3.7, pysql stopped working.
When I check the website of pysql, it states that version 2.1.4 is compatible with python 3.7.

I’ve tried to upgrade pymssql, but it gives me a DeprecationWarning:

(homeassistant) homeassistant@homeassistant:/home/pi $ pip3 install --upgrade pymssql
Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
Collecting pymssql
  Using cached https://files.pythonhosted.org/packages/2e/81/99562b93d75f3fc5956fa65decfb35b38a4ee97cf93c1d0d3cb799fffb99/pymssql-2.1.4.tar.gz
    ERROR: Complete output from command python setup.py egg_info:
    ERROR: /srv/homeassistant/lib/python3.7/site-packages/setuptools/dist.py:45: DistDeprecationWarning: Do not call this function
      warnings.warn("Do not call this function", DistDeprecationWarning)
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-install-maqg50yl/pymssql/setup.py", line 88, in <module>
        from Cython.Distutils import build_ext as _build_ext
    ModuleNotFoundError: No module named 'Cython'
    ----------------------------------------
ERROR: Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-install-maqg50yl/pymssql/

Thought it might be the pip installer being out-of-date but:

(homeassistant) homeassistant@homeassistant:/home/pi $ pip3 install --upgrade pip
Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
Requirement already up-to-date: pip in /srv/homeassistant/lib/python3.7/site-packages (19.1.1)

Any help on this one?

Hy,

You need to install cython first.
pip install cython