There's a whole dedicated thread on this topic. Does work in Sonoma. Chris already had it working on June 6th.
Support macOS Sonoma 14
github.com
Use version 16 of the patcher. Any adapter that is RTL8812AU (realtek) based should also work with this method. The Fenvi AC1300 adapter is RTL8812BU based and will work the same way that TP-Link/Realtek adapters do.
UPDATE: 9/30/23 If you use OpenCore and have installed Sonoma 14.0 Chris1111 has a method to let you keep SIP enabled while using a Realtek USB Wifi adapter. Here's the video instructional to re-enable SIP by Chris-1111 Also See: https://github.com/chris1111/Wireless-USB-Big-Sur-Adapter...
www.tonymacx86.com