Checked other resources

• I added a very descriptive title to this issue.
• I searched the LangChain documentation with the integrated search.
• I used the GitHub search to find a similar question and didn't find it.
• I am sure that this is a bug in LangChain rather than my code.
• The bug is not resolved by updating to the latest stable version of LangChain (or the specific integration package).

Example Code

Steps to reproduce using Poetry as dependency management:

poetry add sqlalchemy@^2.0.36

Attempt to add langchain-community:

poetry add langchain-community

Error Message and Stack Trace (if applicable)

Because no versions of langchain-community match >0.3.8,<0.4.0
and langchain-community (0.3.8) depends on SQLAlchemy (>=1.4,<2.0.36), langchain-community (>=0.3.8,<0.4.0) requires SQLAlchemy (>=1.4,<2.0.36).
So, because search-api-worker depends on both sqlalchemy (^2.0.36) and langchain-community (^0.3.8), version solving failed.

Description

• I'm trying to install langchain-community with SQLAlchemy version ^2.0.36, but encountered a dependency conflict casued by the SQLAlchemy version constraint.
• Downgrading to langchain-community==0.3.4 works.

Would be great if langchain-community dependency requirements would allow compatibility with SQLAlchemy 2.x.

System Info

System Information

OS: Windows
OS Version: 10.0.22631
Python Version: 3.13.0 (tags/v3.13.0:60403a5, Oct 7 2024, 09:38:07) [MSC v.1941 64 bit (AMD64)]

Package Information

langchain_core: 0.3.21
langchain: 0.3.8
langchain_community: 0.3.4
langsmith: 0.1.146
langchain_ollama: 0.2.0
langchain_text_splitters: 0.3.2

Optional packages not installed

langserve

Other Dependencies

aiohttp: 3.11.7
async-timeout: Installed. No version info available.
dataclasses-json: 0.6.7
httpx: 0.27.2
httpx-sse: 0.4.0
jsonpatch: 1.33
numpy: 1.26.4
ollama: 0.3.3
orjson: 3.10.12
packaging: 24.2
pydantic: 2.10.2
pydantic-settings: 2.6.1
PyYAML: 6.0.2
requests: 2.32.3
requests-toolbelt: 1.0.0
SQLAlchemy: 2.0.36
tenacity: 9.0.0
typing-extensions: 4.12.2