Modify a Magento SQL database where condition with an alternate condition

modifyWhereCondition.php

<?php
...
    
/**
 * Modify a WHERE condition in a collection's select statement.
 *
 * @param \Magento\Framework\Data\Collection\AbstractDb $collection The collection to modify.
 * @param string $searchCondition The condition part to search for in the WHERE clause.
 * @param string $replaceCondition The condition part to replace with in the WHERE clause.
 * @return void
 */
function modifyWhereCondition($collection, $searchCondition, $replaceCondition) {
    // Get the WHERE part of the query
    $where = $collection->getSelect()->getPart(\Magento\Framework\DB\Select::WHERE);

    // Clear the WHERE part of the query
    $collection->getSelect()->reset(\Magento\Framework\DB\Select::WHERE);

    // Iterate over each WHERE condition and make replacements as necessary
    foreach ($where as $key => $value) {
        if (str_contains($value, $searchCondition)) {
            $where[$key] = str_replace($searchCondition, $replaceCondition, $value);
        }
    }

    // Set the modified WHERE part back into the collection's select statement
    $collection->getSelect()->setPart(\Magento\Framework\DB\Select::WHERE, $where);
}

// Usage example:
// Assuming $collection is your collection instance, modify the WHERE condition as needed.
modifyWhereCondition(
    $collection,
    'stock_status_index.stock_status = 1',
    '(stock_status_index.stock_status = 1 OR e.status = 1)'
);