SQLite has been written using C language, and its creator has enabled it to be exposed and has enhanced its functionality by having an API, the C API. In general, SQLite has many different API calls, for example, about 200 APIs for different functionalities. As a programmer, you may find it hard to accept, but the APIs are designed for specific tasks, for example, the sqlite3_reset()
function clears the object connected with the SQLite prepared statement and resets it to its original state and value.
To start with, the two core objects are the database connection and the prepared statement objects. The order and the types of functions give you an idea of how to write an SQL transaction to connect to a database, create a table and an index, and populate it with an insert
statement. These functions form the main elements of the SQL-C interface functions, allowing data to be connected and passed from code to SQLite.