除了SQLite文档中的数组示例之外，这里还有一些其他简单的方法来处理SQLite生成的平面列表：

package require sqlite3

sqlite3 db1 :memory:
db1 nullvalue NULL

db1 eval {CREATE TABLE t1(a int, b text)}

db1 eval {INSERT INTO t1 VALUES(1,'hello')}
db1 eval {INSERT INTO t1 VALUES(2,'goodbye')}
db1 eval {INSERT INTO t1 VALUES(3,'howdy!')}
set x [db1 eval {SELECT * FROM t1 ORDER BY a}]

puts $x
>1 hello 2 goodbye 3 howdy!

foreach {a b} $x {
  puts "$a | $b"
}
>1 | hello  
>2 | goodbye
>3 | howdy!

foreach {a b} $x {
  set d [dict set d $a $b]
}
puts $d
>1 hello 2 goodbye 3 howdy!

for {set i 1} {$i < 4} {incr i} {
  puts [dict get $d $i]
}
>hello
>goodbye
>howdy!

对于短或窄的结果集，这些方法有时很方便。