Warning: This build has drifted.
The coverage report for this pull request build may be inaccurate because its base commit is no longer the HEAD of its target branch.
This means it includes changes from outside the original pull request, including, potentially, unrelated coverage changes.

    • Learn more: For more information on this, see Tracking coverage changes for pull request builds.
    • Fix now: For a quick fix, rebase this PR at GitHub. Your next report should be accurate.
    • Prevent going forward: To avoid this issue with future PRs, see these Recommended CI Configurations.

revert: remove unsupported CTE placement assertion

Revert bb8a396, which treated nested WITH placement as a semantic requirement. The PostgreSQL-backed test already verifies SELECT-based CTE behavior. Hoisting can be valid for SELECT CTEs and is required for data-modifying CTEs, which PostgreSQL permits only at the top level; an ordering assertion would encode an implementation detail and block a correct future implementation.