Change Yoast canonical URL in bulk for all posts for consolidation/migration by updating the meta field

bulk-edit-yoast-canonical-url.php

add_action( 'wp_head', function () {
    if ( isset( $_GET[ 'bulk-edit-canonical-url' ] ) ) {
        $args  = [
            'post_type'        => 'post',
            'suppress_filters' => true,
            'posts_per_page'   => -1,
            'post_status'      => [ 'publish', 'pending', 'draft', 'auto-draft', 'future', 'private', 'inherit' ],
        ];
        $loop  = new WP_Query( $args );
        while ( $loop->have_posts() ) : $loop->the_post();
            update_post_meta( get_the_ID(), '_yoast_wpseo_canonical', str_replace( 'old-url.com', 'new-url.com', get_the_permalink() ) );
        endwhile;
        wp_reset_postdata();
    }
} );