Get data of products from SKU or ID or Handles...

Shopify Expert
148 0 26
If I have list of products (Ids, handles,  SKUs), I want to show those products on a theme page (custom template) as a search result. How I can generate a query/search to Shopify to return products for that list of Ids or SKUs... without any limit (I saw a way using product handles i think, but it's limited to 20 or 50 products)