You can load products by SKU in Magento 2 and then use the details for either developing an SKU based feature or fulfill any business requirements!
Attachment 14697
Learn the easy programmatic method at https://meetanshi.com/blog/load-products-by-sku-in-magento-2/