👋 Hello, team! Seeing Error ERROR: Could not build wheels for pymssql while installing

target-mssql

on macOS, python3.10. Has anyone encountered this error for target-mssql? Wondering whether to try installing pymssql directly:

2023-12-07T12:54:48,651 Successfully built target-mssql pendulum
2023-12-07T12:54:48,652 Failed to build pymssql
2023-12-07T12:54:48,652 ERROR: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects
2023-12-07T12:54:48,652 Exception information:
2023-12-07T12:54:48,652 Traceback (most recent call last):
2023-12-07T12:54:48,652   File "/Users/<..>/Documents/my-meltano-project/.meltano/loaders/target-mssql/venv/lib/python3.10/site-packages/pip/_internal/cli/base_command.py", line 180, in exc_logging_wrapper
2023-12-07T12:54:48,652     status = run_func(*args)
2023-12-07T12:54:48,652   File "/Users/<..>/Documents/my-meltano-project/.meltano/loaders/target-mssql/venv/lib/python3.10/site-packages/pip/_internal/cli/req_command.py", line 245, in wrapper
2023-12-07T12:54:48,652     return func(self, options, args)
2023-12-07T12:54:48,652   File "/Users/<..>/Documents/my-meltano-project/.meltano/loaders/target-mssql/venv/lib/python3.10/site-packages/pip/_internal/commands/install.py", line 429, in run
2023-12-07T12:54:48,652     raise InstallationError(
2023-12-07T12:54:48,652 pip._internal.exceptions.InstallationError: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects
2023-12-07T12:54:48,727 Remote version of pip: 23.3.1
2023-12-07T12:54:48,727 Local version of pip:  23.3.1
2023-12-07T12:54:48,727 Was pip installed by pip? True
2023-12-07T12:54:48,728 Removed build tracker: '/private/var/folders/4d/q_40zcp50cz8mhx5904xbpv00000gq/T/pip-build-tracker-hnwrhybh'

I have a ticket in my name to look at this ... but so far, there are still no public shared runners for Apple M1 chips available from Github. https://github.com/pymssql/pymssql/issues/763