Sqlalchemy Turbodbc missing library: libsimdutf.so.9

[amgcc]

After upgrading my conda environment today, package simdutf changed from version 5.4.15 to 5.5.0. Afterward, I started recieving errors with sqlalchemy about a missing library. I'm not sure if this is something that needs to be fixed in sqlalchemy or turbodbc because I don't understand the issue based on the error message.

    return sa.create_engine(conn_str, **kwargs)
../../../../envs/linux_py311/lib/python3.11/site-packages/sqlalchemy/util/deprecations.py:375: in warned
    return fn(*args, **kwargs)
../../../../envs/linux_py311/lib/python3.11/site-packages/sqlalchemy/engine/create.py:518: in create_engine
    entrypoint = u._get_entrypoint()
../../../../envs/linux_py311/lib/python3.11/site-packages/sqlalchemy/engine/url.py:662: in _get_entrypoint
    cls = registry.load(name)
../../../../envs/linux_py311/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py:341: in load
    return impl.load()
../../../../envs/linux_py311/lib/python3.11/site-packages/importlib_metadata/__init__.py:209: in load
    module = import_module(match.group('module'))
../../../../envs/linux_py311/lib/python3.11/importlib/__init__.py:126: in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
../../../../envs/linux_py311/lib/python3.11/site-packages/sqlalchemy_turbodbc/dialect.py:24: in <module>
    from .connector import TurbodbcConnector
../../../../envs/linux_py311/lib/python3.11/site-packages/sqlalchemy_turbodbc/connector.py:16: in <module>
    from turbodbc import make_options
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 

    from importlib.metadata import version
    
>   from turbodbc_intern import Megabytes, Rows
E   ImportError: libsimdutf.so.9: cannot open shared object file: No such file or directory

[alippai]

The work in #433 by @xhochy could solve this

[alippai]

@xhochy looks like this is solved for turbodbc 5.0.1, however that version requires numpy>=2.0. Is this intentional? With numpy 1.26 and python 3.10 turbodbc version 4.13.0 is resolved on conda-forge now (which fails if simdutf<5.5 is not added as well as a pin).

[xhochy]

turbodbc=5.0.1 should only require numpy>=2 in the build environment but should run also with e.g. numpy=1.26

[xhochy]

Should be fixed by conda-forge/turbodbc-feedstock#138

[xhochy]

Furthermore conda-forge/simdutf-feedstock#31 should ensure that this doesn't happen again.

[xhochy]

Both are merged, so should be solved in 1-2h when everything has hit the CDN.

[alippai]

Thanks! 🚀