PyObdc on Mac M2

Hello,

I am a student and would like to continue developing an application using Microsoft Server SQL. I currently run a MAC M2 and I keep getting this error when I try to use pyobdc to connect to the aws RDS:

ERROR: ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/pyodbc.cpython-311-darwin.so, 0x0002): symbol not found in flat namespace '_SQLAllocHandle'