sqlalchemy: Filtering in async with relationship doesn't work

Describe the bug

Selection with inload works normally, it loads all the relationship, but if I am also trying to filter this selection, then the relationship for some reason stops loading.

To Reproduce

import asyncio
from pprint import pprint

from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.ext.asyncio import AsyncSession, create_async_engine
from sqlalchemy.future import select
from sqlalchemy.orm import (declarative_base, relationship, selectinload,
                            sessionmaker)

Base = declarative_base()

class Node(Base):
    __tablename__ = "nodes"

    id = Column(Integer, primary_key=True, unique=True)
    parent_id = Column(Integer, ForeignKey('nodes.id'), nullable=True)
    children = relationship("Node")

    name = Column(String)


def serialize(o):
    if isinstance(o, Base):
        return {name: serialize(getattr(o, name))
                for name in dir(o)
                if not name.startswith("_")}
    elif isinstance(o, list):
        return [serialize(i) for i in o]
    return o


async def async_main():
    engine = create_async_engine(
        "sqlite+aiosqlite:///./sqlite.db",
        future=True,
        connect_args={"check_same_thread": False},
    )

    async with engine.begin() as conn:
        await conn.run_sync(Base.metadata.drop_all)
        await conn.run_sync(Base.metadata.create_all)

    async_session = sessionmaker(
        bind=engine, expire_on_commit=False, class_=AsyncSession
    )

    root_id = 1
    async with async_session() as session:
        async with session.begin():
            session.add(Node(name="root", children=[
                Node(name="1", children=[Node(name="11"), Node(name="12")]),
                Node(name="2", children=[Node(name="21")]),
                Node(name="3", children=[Node(name="31"), Node(name="32")]),
            ]))

    async with async_session() as session:
        async with session.begin():
            stmt = (select(Node)
                    .options(selectinload(Node.children))
                    # neither of those work
                    # .filter(Node.id == root_id)
                    # .filter_by(id=root_id)
                )
            result = await session.execute(stmt)
            pprint(serialize(result.scalars().first()))


asyncio.run(async_main())

Error

Uncomment one of filter or filter_by:

Traceback (most recent call last):
    ...
    raise exc.MissingGreenlet(
sqlalchemy.exc.MissingGreenlet: greenlet_spawn has not been called; can't call await_() here. Was IO attempted in an unexpected place? (Background on this error at: https://sqlalche.me/e/14/xd2s)
sys:1: RuntimeWarning: coroutine 'Connection.cursor' was never awaited

Versions

• OS: Windows10
• Python: 3.10.0rc1
• SQLAlchemy: 1.4.34
• Database: sqlite
• DBAPI (eg: psycopg, cx_oracle, mysqlclient): aiosqlite

Additional context

I expect to see the same result both with filtration and without it:

{'children': [{'children': [{'children': [],
                             'id': 3,
                             'metadata': MetaData(),
                             'name': '11',
                             'parent_id': 2,
                             'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>},
                            {'children': [],
                             'id': 4,
                             'metadata': MetaData(),
                             'name': '12',
                             'parent_id': 2,
                             'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>}],
               'id': 2,
               'metadata': MetaData(),
               'name': '1',
               'parent_id': 1,
               'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>},
              {'children': [{'children': [],
                             'id': 6,
                             'metadata': MetaData(),
                             'name': '21',
                             'parent_id': 5,
                             'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>}],
               'id': 5,
               'metadata': MetaData(),
               'name': '2',
               'parent_id': 1,
               'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>},
              {'children': [{'children': [],
                             'id': 8,
                             'metadata': MetaData(),
                             'name': '31',
                             'parent_id': 7,
                             'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>},
                            {'children': [],
                             'id': 9,
                             'metadata': MetaData(),
                             'name': '32',
                             'parent_id': 7,
                             'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>}],
               'id': 7,
               'metadata': MetaData(),
               'name': '3',
               'parent_id': 1,
               'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>}],
 'id': 1,
 'metadata': MetaData(),
 'name': 'root',
 'parent_id': None,
 'registry': <sqlalchemy.orm.decl_api.registry object at 0x0000017F7F1942E0>}