BASE 44 ORDER: Implement has_2_torsion column, index, cache, backfill, and harness test — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1172] Add has_2_torsion boolean column with regex update on insert. Create partial index. Modify agent search to query indexed rows pre-LLM. Implement in-memory TTL cache keyed by (has_2_torsion, search_hash). Add nightly SQL job for backfill. Run harness test. MERLIN: Understood. I'll add the has_2_torsion boolean column with regex update on insert, create a partial index, modify agent search to query indexed rows pre-LLM, implement the in-memory TTL cache keyed by (has_2_torsion, search_hash), add the nightly SQL backfill job, and run the harness test. The swarm will execute this build now and report results. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com