@gcincilla from what I see the default setting for SQLite connector for NUMERIC is indeed String which results in notations like this:
If you switch this setting to Double → Number Float everything should be fine, given that you want all NUMERIC fields being treated in this way:
You might have to apply a Number format manager:
Another option is to set these types based on the individual names of the columns. You can do this in the SQLite connector or in the DB Query Reader.
