db:first_row(sql)

Execute a SQL statement and return the first row of data. The columns are returned as a table using the column names from the SQL statement instead of as an integer indexed array.

db=sqlite.open('testdb')
row=db:first_row[[select max(x) as biggest from
foo]] max_x = row.biggest