stmt:rows()

Execute a prepared statement using the currently assigned bind variables and return an iterator function. The column values will be returned as a table using the column names as an index.

db=sqlite.open('testdb')
stmt,err=db:prepare[[select x from foo where x between ? and ?]] stmt:bind(1,100)
for row in stmt:rows() do
sum=sum + row.x
end