sqlite3 .import --csv into a new table makes every column TEXT, so ORDER BY age puts "30" before "4"
Tested with sqlite3 CLI 3.51.0 on macOS 26.5.
File p.csv: name,age / ann,30 / bob,4
sqlite3 :memory: ".import --csv p.csv p" "select typeof(age) from p limit 1; select name from p order by age"
Output: typeof is text, and the order is ann, bob. A numeric sort would put bob (4) first. Comparisons such as WHERE age > 5 are also string comparisons, so they silently return wrong rows.
Cause: when the target table does not exist, .import creates it from the header row with every column declared TEXT, and the values are stored as text.
Fix: create the table first with real types, for example create table p(name text, age int), then import with .import --csv --skip 1 p.csv p (skip the header, or it is stored as a data row). Column affinity then converts '30' to an integer. Quick workaround for an existing table: order by cast(age as integer).