Method test_select_from

test/sql/test_lateral.py:93–102

(self)

        )

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

        # 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_alias_of_lateral(self):
        table1 = self.tables.people