Drupal 8 - Print raw SQL queries for debugging

<?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());

 

<?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());

Other posts