FYI: you don’t need @ionic/app-scripts for modern Ionic projects. It was obsoleted after v3 of the framework.
Your proximate problem seems to be that cordova-sqlite-devtools 1.2.1 is broken. I get the same error you do, and downgrading it by npm i cordova-sqlite-devtools@1.2.0 fixes it for me.