The sqlite provider seems to silently truncate integer values in results: )COPY 5 SQL DUMPED 2017-02-12 10:13:53 (GMT+1) db←'sqlite' SQL∆Connect ':memory:' 'create table a(b)' SQL∆Exec[db] ⍬
'insert into a values(?),(?)' SQL∆Exec[db] 2⋆31 32 'select b from a' SQL∆Select[db] ⍬ ¯2147483648 0 'select cast(b as real) from a' SQL∆Select[db] ⍬ 2147483648 4294967296 -k