Method test_with_subquery

tests/_ast/test_sql_visitor.py:562–567

(self)

        }

    def test_with_subquery(self) -> None:
        sql = "SELECT * FROM table1 WHERE id IN (SELECT id FROM table2);"
        assert find_sql_refs(sql) == {
            SQLRef(table="table2"),
            SQLRef(table="table1"),
        }

    def test_with_subquery_2(self) -> None:
        sql = """