IndexError when using AWS X-Ray SDK with SQLAlchemy

[tomeszmh]

I am encountering an issue when using the AWS X-Ray SDK to trace my AWS Lambda function, which utilizes SQLAlchemy for database operations. When invoking the Lambda function, I receive the following error:

Error getting the sanitized query
Traceback (most recent call last):
  File "/opt/python/aws_xray_sdk/ext/sqlalchemy_core/patch.py", line 46, in _sql_meta
    if isinstance(args[0], ClauseElement):
IndexError: tuple index out of range

I am using the patch_all() function from the AWS X-Ray SDK to patch all available libraries, including SQLAlchemy:
Could you please help me understand the cause of this error and suggest a possible solution? Let me know if you need more information about my implementation or environment.

aws_xray_sdk == 2.12.0
Sqlalchemy == 2.0.14

I added lambda Active tracing too.

Many thanks

[carolabadeer]

The X-Ray Python SDK is currently only compatible with SQLAlchemy < 2.0.0 since v2.0.0 introduced breaking changes, please see #381. We can keep this issue open to track support for SQLAlchemy >= 2.0.0 but, in the meantime, using SQLAlchemy 1.x should resolve this error