Search notes:

SQLite: cast

The cast expression converts between data types.

select
  typeof(     '0'            ) tp_1, -- text
  typeof(cast('0' as integer)) tp_2  -- integer
;