No module named 'aws_advanced_python_wrapper.sqlalchemy.pg_orm_dialect'

[marcm-ml]

Describe the bug

The latest release has an invalid entrypoint for the pg sqlalchemy driver entrypoint.
this file does not exists in the current v3.0.0 release.

Expected Behavior

File exists and driver can be used with sqlalchemy create_engine and a qualified URL.

What plugins are used? What other connection properties were set?

any

Current Behavior

ModuleNotFoundError: No module named 'aws_advanced_python_wrapper.sqlalchemy.pg_orm_dialect'

Reproduction Steps

from sqlalchemy import create_engine

DATABASE_URL = "postgresql+aws_wrapper_psycopg://<host>:<port>/postgres"

engine = create_engine(DATABASE_URL)

Possible Solution

No response

Additional Information/Context

No response

The AWS Advanced Python Wrapper version used

v3.0.0

python version used

3.13.14

Operating System and version

macOS

[marcm-ml]

After digging into the git history, i can see that this most likely was a mistake and in 3.0.0 the sqlalchemy driver was not yet implemented but the entry point was specified regardless.

Any estimates on when the current main branch will be released?

Edit:
While checking out the branch main, I have found a dependency conflict with other aws managed packages:

  × No solution found when resolving dependencies:
  ╰─▶ Because your project depends on aws-advanced-python-wrapper and aws-advanced-python-wrapper==3.1.0 depends on opentelemetry-api>=1.43.0, we can conclude that your project depends on
      opentelemetry-api>=1.43.0.
      And because aws-opentelemetry-distro==0.18.0 depends on opentelemetry-api==1.42.1, we can conclude that aws-opentelemetry-distro==0.18.0 and your project are incompatible.

I think a library (like aws-advanved-python-wrapper) should not have a relative strict bound on the opentelemetry-api package to allow for more flexible dependency resolutions downstream.

[sophia-bq]

Hi @marcm-ml

Thank you for reaching out and raising this issue.
We'll take a look at this and keep you updated as we investigate.

Thank you for your patience!