GET_DOMAINS_TO_VERIFY = """
    SELECT
        email_domain,
        attempts,
    FROM
        email_domain_validation
    WHERE
        (is_valid is NULL) OR ((not is_valid) AND (attempts < 3));
"""

UPDATE_DOMAINS = """
    MERGE INTO
        email_domain_validation old
    USING (
        SELECT
            *
        FROM VALUES
            {values}
    ) AS new (
        email_domain,
        is_valid,
        attempts,
        reason
    )
    ON
        old.email_domain = new.email_domain
    WHEN MATCHED THEN
        UPDATE SET
            is_valid = new.is_valid,
            attempts = new.attempts,
            reason = new.reason,
            updated_at = CURRENT_TIMESTAMP;
"""