Casting an INTEGER or REAL value into TEXT renders the value as if via sqlite3_snprintf() except that the resulting TEXT uses the encoding of the database connection.

所以你可以做这样的事情：

select cast(some_integer_column as text) from some_table;

或者,根据您想要做的,您可以将数字视为字符串,并让sqlite强制其认为合适的类型：

select some_int || ' pancakes' from some_table;
select some_int || '' from some_table;