This application is not designed to be a visual shell for the sqlite command line tool. However, it is capable of the following (and more):

Create and compact database files
Create, define, modify and delete tables
Create, define and delete indexes
Browse, edit, add and delete records
Search records
Import and export records as text
Import and export tables from/to CSV files
Import and export databases from/to SQL dump files
Issue SQL queries and inspect the results
Examine a log of all SQL commands issued by the application

with SQLite v2.x and 3.x standard databases. So, if you need a tool to inspect or modify data for this type of database, SQLite Database Browser maybe for you.

SQLite Database Browser is also a perfectly capable tool for creating standalone databases on the Open Pandora, and because it supports the basic theory behind the relational model, it is a very capable tool. Breaking out data into tables and providing SQL access to the final structure the possibilities whilst not endless, are significantly greater than with more traditional flat file database managers.