(refers to Mel's Internet Toolkit - See also sqlite)
To get results as a list of lists:
set result [tk::db::sqlite::query "select * from users"]
To get all in an array
tk::db::sqlite::query:v -variable myvar "select * from users"
see Login.tcl for examples
Now That's Simple