Inside SQLite’s Frontend: BETWEEN, OR, LIKE, and GLOB Optimizations

SQLite internally rewrites the BETWEEN clause into two comparison terms and uses them for index range scans. OR conditions on the same column are transformed into IN clauses for efficient index usage, while OR conditions on different columns are analyzed separately with results combined. These internal rewrite strategies allow SQLite to optimize seemingly simple operators without requiring explicit user intervention.