You have to provide a schema anyway, so you can treat specific columns as integers.

sqlite won't fail on bad types but you can do maths (e.g. sum, etc) on numeric columns,