As far as I know, you can do something like:

WITH filtered_headers AS (
    SELECT h.header_a_id, h.header_b_id
    FROM unique_headers h
    WHERE h.status = 'ACTIVE'
      AND h.CreatedDate = '2025-01-01'
      AND h.isDeleted = 0
)
SELECT...

So the filter (WHERE condition) is applied earlier.