Comment by andrewstuart

SKIP LOCKED guarantees that a row can only be read once. This is critical for queueing systems.

SQLite does not support SKIP LOCKED.