sqlite.selectOne(dbname,sql,parameters)

Execute a select statement and return the first row as a Lua table.

Example

row = sqlite.selectOne('testdb', 'select max(x) from foo')

max_x = row[1]