Post ensinando a como exibir query (sql) de uma collection no Magento 2
$collection->load();
// the following statements are equivalent
$collection->getSelect()->assemble();
$collection->getSelect()->__toString();
echo $collection->getSelect();
Função responsável: echo $collection->getSelect();