There are 2 basic types of adapters on the market: the WH-125 and the Adafruit. Both use the same micropython driver and have the same pins for connections as an SPI peripheral. They can also be mounted and used in circuitpython using the Adafruit libraries. They are directly interchangeable in software but you have to be extremely careful when making the physical connections otherwise you get “no SD card” or other errors that can be puzzling.
It may be necessary to physically move some of the pin connections when you need to add additional peripherals e.g. external temperature probe. When making changes to pin layout, keep track of which pins are associated with each function on SPI bus you are using. SPI0 and SPI1 pins do not overlap. MISO, MOSI, clock and select are limited to specific GPIO pins in each bus.
A great resource is https://randomnerdtutorials.com/raspberry-pi-pico-w-pinout-gpios/#spi

I had to resort to switching between 2 breadboards connected to Thonny so I could test the adapters separately and efficiently. There are multiple examples of programs for testing and using the microSD card adapter. They work but are not all the same code. There may be an example that is easier to understand and adapt to your specific needs.

The sdcard.py driver is found at https://github.com/micropython/micropython-lib/tree/master/micropython/drivers/storage/sdcard
Example test code:
Circuitpython: https://github.com/printnplay/Pico-CircuityPython/blob/main/SDCartTest.py
Micropython: https://randomnerdtutorials.com/raspberry-pi-pico-microsd-card-micropython/#datalogging
Micropython: https://core-electronics.com.au/guides/makerverse-micro-sd-adapter-micropython-guide/#modules

