I only use the sqlite CLI to look at sqlite databases.
have you ever seen/used db browser for sqlite?
i used it to design a db and query.
i am a fan of tools with GUI.
No, and I’m unlikely to. Im a fan of GUI tools too, but in this case I use the CLI because it is written and maintained by the sqlite3 folks. Therefore if I want to try something it’s the best tool to use. I can try something and be confident that the SQL I try with it will move into my app with no issues. If you try to report an issue on the SQLite Forum, the first question they will ask is whether you’ve tried it with the CLI or not. If not, they’ll tell you to do so as first step.