sqlite statement

Returns a sqlite statement object that can be used to retrieve the results. This property will return error if:

• A syntax error exists, or
• The SQL statement modifies the database in any way. This includes some PRAGMA statments as well.

If successful, SQLite compiles the SQL statement into byte code and is ready to retrieve the results. This property does not have a display format. "This expression evaluates to an unrepresentable object of type sqlite statement" will be shown instead.

SQLite understands most of the standard SQL language. However it does omit some features as well as adding a few features of its own. For more details, visit the SQLite documentation on this subject.

Returns the result of the select query. The rows are written as a list of CSV strings. Decimal numbers are set to display 3 decimal places. Due to the difficulty in displaying blobs, in which one cell could be hundreds of lines, if a cell in a table is a BLOB type, then "Blob" is displayed. Likewise, if a cell in a table is NULL, then "NULL" is displayed.