[nick_]

IIRC Sqlite stores all data types as text. It seems like a very weird decision to me.

[ncruces]

This is wrong. Integers (in SQLite columns) are stored as varints and floats as IEEE 754 doubles. Numbers in JSONB are stored as text.