I now also add the Common Table Expression (CTE) names to the known tables, so they will not be re-added (thus cross-joined with self).

The following snippet (from the issue) was used to validate the change:

    from sqlalchemy import create_engine, MetaData, select, func as F, Table, Column, Integer, ARRAY

    metadata = MetaData()

    table = Table(
        "table1",
        metadata,
        Column("foo", Integer),
        Column("bars", ARRAY(Integer))
    )
    engine = create_engine("bigquery://", future=True)

    selectable = sql.select(table.c).select_from(table).cte('cte')
    q = sql.select([selectable.c.foo, sql.func.unnest(selectable.c.bars).column_valued('unnest_bars')]).select_from(selectable)
    print(q.compile(engine))

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

• Make sure to open an issue as a bug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
• Ensure the tests and linter pass
• Code coverage does not decrease (if any source code was changed)
• Appropriate docs were updated (if necessary)

Related #368