async def METHOD_NAME(self):
    # Check that nested WITH blocks work correctly, with and
    # without DETACHED.
    await self.assert_query_result(
        """
            WITH MODULE foo
            SELECT (
                Entity.name,
                fuz::Entity.name
            );
        """,
        [['entity', 'fuzentity']],
    )
    await self.assert_query_result(
        """
            WITH MODULE foo
            SELECT (
                Entity.name,
                (WITH MODULE fuz SELECT Entity.name)
            );
        """,
        [['entity', 'fuzentity']],
    )
    await self.assert_query_result(
        """
            WITH MODULE foo
            SELECT (
                Entity.name,
                (WITH MODULE fuz SELECT DETACHED Entity.name)
            );
        """,
        [['entity', 'fuzentity']],
    )