To accomplish this task manually, the free tool, SQLite Database Browser, is being utilized to open and query the database for those items of interest.

The SELECT statement is what is used to retrieve specific data from these databases. When writing a SELECT statement, you must identify:

1) The information you wish to retrieve (columns)

2) The table that contains the above information using the previous database as an example, to pull:

•  The User

•  Message Timestamp

•  Content of the Message

•  The Timestamp that the Message was Received

A simple SQLite query would be:
SELECT
ZUSER,
ZTIMESTAMP,
ZBODY,
ZRECEIVEDTIMESTAMP
FROM ZKIKMESSAGE

where ZUSER, ZTIMESTAMP, ZBODY, and ZRECEIVEDTIMESTAMP are the columns and ZKIKMESSAGE is the table.

Pay special attention to the commas that separate each column. More detailed instructions on generating SELECT statements can be found in the link in the reference below.¹
This information was entered into SQLite Database Browser by selecting the tab “Execute SQL”.

Reference:

[1] https://for585.com/sqlitestatements