I wrote DBD::SQLite::Database#columns method.
CREATE TABLE TEST (
KEY TEXT NOT NULL PRIMARY KEY,
FLAG BOOLEAN,
DATA TEXT
);
# BEFORE SQLite.c.patch
dbi => \dt test
Table 'test':
+------+-----------+-----------+-------+---------+----------+---------+---------+--------+
| name | type_name | precision | scale | default | nullable | indexed | primary | unique |
+------+-----------+-----------+-------+---------+----------+---------+---------+--------+
+------+-----------+-----------+-------+---------+----------+---------+---------+--------+
# AFTER SQLite.c.patch
dbi => \dt test
Table 'test':
+------+-----------+-----------+-------+---------+----------+---------+---------+--------+
| name | type_name | precision | scale | default | nullable | indexed | primary | unique |
+------+-----------+-----------+-------+---------+----------+---------+---------+--------+
| KEY | TEXT | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| FLAG | BOOLEAN | NULL | NULL | NULL | true | NULL | NULL | NULL |
| DATA | TEXT | NULL | NULL | NULL | true | NULL | NULL | NULL |
+------+-----------+-----------+-------+---------+----------+---------+---------+--------+
|
