I want to dig deeper into Magentos SQL adapter. There are a lot of answer that often suggests to use Magentos own implementation of the SQL-Adapter.
I currently want to do this SQL in a resource Model:
SELECT pd.sku FROM wishlist_item AS wl LEFT JOIN catalog_product_entity AS pd ON pd.entity_id = wl.product_id WHERE wl.wishlist_id = 2;
How would I transform that into Magento Code if I shall not use