cordova-sqlite adapter can be used with cordova and capacitor. The article says so.
Also wasn't sure whether it was being suggested to use the react (native) plugin or the cordova plugin, as I didn't clarify (I should have) in the parent that I'm using react js and not native.