If you ever need to edit a SQLite database on Android then use the app I built: SqlitePrime.
You can use the built-in SQL Editor, view and edit fields, create Tables, view DDL for Tables, Views, Indices, Triggers.
It also has support for editing the Blob data type.
You can also edit app's databases (Root needed)
https://forum.xda-developers.com/android/apps-games/app-sqliteprime-database-manager-root-t3684598
The app can also be downloaded from here https://sqlite-prime.en.aptoide.com/ in case you can't download it from Play Store.
TODO: Migrate Sqlite Prime app entirely to Kotlin with MVVM and Open source it (I'm planning to do this when I find a bit more free time).