In Magento 2.4, customer can request to be notified of product which is back in stock. However, to view which product has customer requested to be notified, we need to go to each of the product detail page and view the information under product alert.
Hence, the other way to retrieve the list at one go is to query from the database.
Below is the SQL to extract the list of products and customers who wish to be notified when the products are back in stock.