No. You cannot use a simple “adapter” to use a Lightning accessory with USB-C. Lightning and USB-C interfaces are completely different - and are not inter-workable.
Plug-adapters that you might see advertised are only intended to be used for charging. You should note that USB-C does not certify adapters - and all such adapters lack the protective circuitry that is designed to protect both the connected cable and device from damaging misconnection.
Instead of looking for an adapter, you should simply invest in the correct USB-C SD Card Adapter - or USB-C hub that incorporates an SD Card reader.
Apple’s official USB-C to SD Card Reader:
https://store.apple.com/uk/xc/product/MUFG2ZM/A