Describe the bug

It seems that the one-to-one example for a relationship does not infer correctly the uselist value if the mapped argument is not a string annotation.

The difference is in the value inferred for uselist in the Parent.child relationship, that is correctly inferred to False in the example, while it is inferred to True if the type annotation for child is changed to Mapped[Child].

In the docs of the uselist parameter (https://docs.sqlalchemy.org/en/20/orm/relationship_api.html#sqlalchemy.orm.relationship.params.uselist) it is stated that uselist may be derived from whether the mapped argument is a collection or not, but in this case Mapped[Child] is not a collection, so I would expect uselist set to False.

Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected

https://docs.sqlalchemy.org/en/20/orm/relationship_api.html#sqlalchemy.orm.relationship.params.uselist

SQLAlchemy Version in Use

2.0.24

DBAPI (i.e. the database driver)

psycopg2

Database Vendor and Major Version

PostgreSQL 13

Python Version

3.10

Operating system

Windows

To Reproduce

from sqlalchemy import ForeignKey
from sqlalchemy.orm import Mapped, mapped_column, relationship, DeclarativeBase


class Base(DeclarativeBase):
    pass


class Child(Base):
    __tablename__ = "child"

    id: Mapped[int] = mapped_column(primary_key=True)
    parent_id: Mapped[int] = mapped_column(ForeignKey("parent.id"))
    parent: Mapped["Parent"] = relationship(back_populates="child")


class Parent(Base):
    __tablename__ = "parent"

    id: Mapped[int] = mapped_column(primary_key=True)
    # this relationship has uselist=True
    child: Mapped[Child] = relationship(back_populates="parent")
    # this relationship has uselist=False
    # child: Mapped["Child"] = relationship(back_populates="parent")

Error

# Copy the complete stack trace and error message here, including SQL log output if applicable.

Additional context

No response