Method test_select_from_implicit_subquery

test/sql/test_lateral.py:117–126

(self)

        )

    def test_select_from_implicit_subquery(self):
        table1 = self.tables.people
        subq = select(table1.c.people_id)

        # in a FROM context, now you get "AS alias" and column labeling
        self.assert_compile(
            select(subq.lateral(name="alias")),
            "SELECT alias.people_id FROM LATERAL "
            "(SELECT people.people_id AS people_id FROM people) AS alias",
        )

    def test_select_from_text_implicit_subquery(self):
        table1 = self.tables.people