The SQLite CLI allows you to issue any valid SQL statements you like. To create SQLite database records, simply issue the appropriate SQL insert commands. Similarly, to list the records you simply ...

Later, in the Implementation Guide you can read about use of INSERT, UPDATE and DELETE queries ... It depends upon the problem that the query is being designed to resolve.