Programmatically you can use any other approach to get the same results.
You can load product by SKU with two methods.
• Object Manager
• Factory Method
Object Manager
A short method but nor recommended but Magento.

$sku =”ABC”;
$objectManager = \Magento\Forum\App\ObjectManager::getInstance();
$product = $objectManager->get(‘Magento\Catalog\Model\Product’)->loadByAttribute(‘sku’,$sku);
Factory Method
Recommended method by Magento.
<?php 
namespace FME\Module\Block; 

class Product extends \Magento\Framework\View\Element\Template
 {

  protected $_productloader; 


  public function __construct( 
         \Magento\Catalog\Model\ProductFactory $_productloader 


         ) { 


         $this->_productloader = $_productloader;

           }
public function getLoadProduct($sku)
    {
        return $this->_productloader->create()->loadByAttribute('sku', $sku);
    }


}

phtml File Code

$product = $this ->getLoadProduct(“ABC”);
echo $product->getName();

Complete Tutorial on Magento 2 Load Products by SKU https://www.fmeextensions.com/blog/magento-2-load-product-by-sku/