Drupal 8 - Print raw SQL queries for debugging

databaseService.php

<?php

/**
 * Debugging using the database connection.
 */

/** @var \Drupal\Core\Database\Connection */
$connection = \Drupal::service('database');
$query = $connection->select('node', 'node');
$query->fields('node', ['nid'])
  ->condition('node.type', 'page')
  
// Debug.
dump($query->__toString());

queryFactoryService.php

<?php

/**
 * Debugging using the query factory.
 */

// Update the Drupal\Core\Entity\Query\Sql\Query & change the property $sqlQuery to be public then...
$queryFactory = \Drupal::service('entity.query');
$query = $queryFactory->get('node');
$query->condition('type', 'page'):

// Debug.
dump($query->execute());
dump($query->sqlQuery->__toString());