问如何引用sqlalchemy中的UNION结果的列？

EN

from sqlalchemy import (
    create_engine,
    Integer,
    String,
)
from sqlalchemy.schema import (
    Column,
)
from sqlalchemy.sql import select, union
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import Session


Base = declarative_base()


engine = create_engine("sqlite://", echo=False)


class Animal(Base):
    __tablename__ = 'animals'
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String)

class Human(Base):
    __tablename__ = 'humans'
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String)

class NameDirectory(Base):
    __tablename__ = 'name_directories'
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String)


Base.metadata.create_all(engine)

with Session(engine) as session:
    dog = Animal(name='Spot')
    human = Human(name='Guy')
    human2 = Human(name='Man')
    session.add_all([dog, human, human2])
    for obj in (dog, human):
        session.add(NameDirectory(name=obj.name))
    session.commit()

with Session(engine) as session:
    all_names = session.query(Animal.name.label("name")).union(session.query(Human.name.label("name"))).subquery('all_names')
    query = session.query(NameDirectory.name).join(all_names, all_names.c.name == NameDirectory.name)
    print(query)
    print(query.all())

with Session(engine) as session:
    q1 = select([Animal.name.label('name')]).select_from(Animal)
    q2 = select([Human.name.label('name')]).select_from(Human)
    sub = union(q1, q2).alias()
    q = select([sub.c.name]).select_from(sub.join(NameDirectory, sub.c.name == NameDirectory.name))
    print(q)
    print(session.execute(q).all())

SELECT name_directories.name AS name_directories_name 
FROM name_directories JOIN (SELECT anon_1.name AS name 
FROM (SELECT animals.name AS name 
FROM animals UNION SELECT humans.name AS name 
FROM humans) AS anon_1) AS all_names ON all_names.name = name_directories.name
[('Spot',), ('Guy',)]
SELECT anon_1.name 
FROM (SELECT animals.name AS name 
FROM animals UNION SELECT humans.name AS name 
FROM humans) AS anon_1 JOIN name_directories ON anon_1.name = name_directories.name
[('Spot',), ('Guy',)]