Small. Fast. Reliable.
Choose any three.

SQLite C Interface

Virtual Table Scan Flags

#define SQLITE_INDEX_SCAN_UNIQUE      1     /* Scan visits at most 1 row */

Virtual table implementations are allowed to set the sqlite3_index_info.idxFlags field to some combination of these bits.

See also lists of Objects, Constants, and Functions.