Skip to main content

RawQueryResult

A raw array-based result set representing rows returned by SQLite.

Extends

Properties

PropertyTypeDescriptionInherited from
columnNamesstring[]Names of columns in this result set. Every column has a name, so the length of this array is always equal to the amount of columns in the result set. Note that column names are not necessarily unique, e.g. a SELECT foo.user, bar.user FROM ... will have ['user', 'user'] in this array.-
insertId?numberRepresents the auto-generated row id if applicable.BaseQueryResult.insertId
rawRowsSqliteValue[][]Rows in the result set. Each row has a length equal to RawQueryResult.columnNames.-
rowsAffected?numberNumber of affected rows reported by SQLite for a write query. When using the default client-side JSON-based view system, rowsAffected may be 0 for successful UPDATE and DELETE statements. Use a RETURNING clause and inspect rows when you need to confirm which rows changed.BaseQueryResult.rowsAffected