c.execute('create table bigtop (a int, b int, c int)')
for v in [(1, 2, 3), (4, 5, 6), (7, 8, 9)]:
    c.execute('insert into bigtop values (?,?,?)', v)
s = c.execute('select * from bigtop')
h = [(i[0], int) for i in c.description]
a = asarray(list(s), dtype=h)
print(a['a'])
Получить заголовки SQL из массива Numpy в python