Execute a single SQLite statement and return results
A single statement to run
Result of executing an SQL statement.
Names of columns.
Names of columns can be defined using the AS keyword in SQL:
SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author
Types of columns.
The types are currently shown for types declared in a SQL table. For column types of function calls, for example, an empty string is returned.
Rows produced by the statement.
Number of rows that were affected by an UPDATE, INSERT or DELETE operation.
This value is not specified for other SQL statements.
ROWID of the last inserted row.
This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID table.