SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1
(
  id         the_type_to_store_numbers,
  something  some_magic_type,
  another    "Don't Know"
)
✓
insert into t1 values 
(1, 42, 'Foo'), 
(2, '10:30', 'Bar'), 
("three", 'value', "foo");
✓
select * 
from t1


id
something
another


1
42
Foo

2
10:30
Bar

three
value
foo


create table t2
(
  id,
  something,
  another
)
✓
insert into t2 values 
(1, 42, 'Foo'), 
(2, '10:30', 'Bar'), 
("three", 'value', "foo");
✓
select * 
from t2


id
something
another


1
42
Foo

2
10:30
Bar

three
value
foo