I started reading manuals and examples for java, where I found out how to create db by code; I did not know and had no tools (now I know them).
Then, when I discovered the fantastic B4A, I created everything from code.
Now I have some doubts. I would like to think about the situations of any changes to the DB structure and the distribution, but if anyone thought in my place, I would do my little brain work less .
There's no problem, if you use a DB editor and then your app requires a DB change you can manage that as well, it's just matter of checking the app version and creating an "update DB" routine, I think I've posted some examples, but you can just also search the forums for answers.