No - you cannot use a basic USB-C to Lightning cable to directly connect USB accessories to a Lightning equipped iPad. USB accessories with USB Type-B connections require connection to a host with a USB Controller / USB Root Hub.
However, the required USB hardware components can be added through connection of an Apple Lightning to USB3 Camera Adapter. This adapter contains an Interface converter, USB 3.0 Controller and USB Root Hub - presenting a USB 3.0 Type-A connection to which you may connect many (but not all) categories of USB devices. USB Device support by iPad is generally limited to Mass Storage and basis HID devices (such as wired Keyboard and basic Mouse).
Whilst connection of wired HID devices is supported via a suitable adapter, most users would instead choose to use a Bluetooth Keyboard and/or Mouse. Apple provides advanced support, beyond basic functionality, for the Apple Magic Mouse 2 and Magic Trackpad 2.