ROWID INTEGER PRIMARY KEY that is used.WHERE order_id = ?1 queries benefit from the index.ROWID is unique, but (per my comments above):If you're doing lookups by some form of UUID, then you should create an index on that column so that your WHERE order_id = ?1 queries benefit from the index.
UNIQUE index to prevent duplicate UUIDs (which should be near impossible, but an application bug on your side could re-use the same UUID) - https://developers.cloudflare.com/d1/learning/using-indexes/#when-is-an-index-usefulALTER TABLE RENAME COLUMN? It seems to be failing with not authorized to use function: sqlite_rename_test....schema my_table, but it returns a syntax error, at least in the console.LIKEGLOBThe LIKE OptimizationROWID INTEGER PRIMARY KEYWHERE order_id = ?1ROWIDUNIQUEALTER TABLE RENAME COLUMNnot authorized to use function: sqlite_rename_test.schema my_table