Retrieve a plain SQL query from a Select query object in Drupal 10

plain_sql_query_in_drupal.php

<?php

use Drupal\Core\Database\Database;
use Drupal\Core\Database\Query\SelectInterface;

/**
 * Returns a plain SQL query from a Select query object.
 */
function get_plain_sql_query(SelectInterface $query): string
{
    $sql = $query->__toString();

    $args = $query->getArguments();

    foreach ($args as $key => $value) {
        $sql = str_replace($key, Database::getConnection()->quote($value), $sql);
    }

    return $sql;
}