CODE EXAMPLE FOR PHP

magento 2 select to string

echo $products->getSelect()->__toString();