This adds a numeric table for testing with a column that should be a SQL integer, and some hacks to get both Postgres and SQLite to accept the integer values in this specific case. The general solution should probably look up the column's SQL type in the config and use that in the CAST (if the type is not TEXT).
This adds a
numeric
table for testing with a column that should be a SQL integer, and some hacks to get both Postgres and SQLite to accept the integer values in this specific case. The general solution should probably look up the column's SQL type in the config and use that in theCAST
(if the type is notTEXT
).