db:first_cols(sql)

Execute a SQL statement and return the first row of data. The values are returned directly using the standard Lua feature of returning multiple values from a function.

db=sqlite.open('testdb')

min_x, max_x = db:first_cols[[select min(x), max(x) from foo]]