I think that we can discuss more about the data types in SQLite about INTEGER
according to this link:
https://www.sqlite.org/datatype3.html#affinity
INTEGER are variable data types, so I can store 1 bit or 64 bit value as well.
The problem is when you read data with for example

Statement select(cSQLiteSession);
select << sSelectStatement;
select.execute();

The execute code use the call inside somewhere the function:
MetaColumn::ColumnDataType Utility::getColumnType(sqlite3_stmt* pStmt, std::size_t pos)
that use _types to get the data type. INTEGER is mapped as int32_t and I think this is wrong because if you stored a 64bit timestamp in the INTEGER value you retrieve a wrong value

is it clear?