db_query

db_query(sql, [params]) executes a SELECT query on the SQLite database. Returns an array of row-tables with column-value pairs.

Signature

db_query(sql, [params])

async

Note

Available only on the SQL (SQLite) build variant. Integer/Real/Text/Null SQL types map to Lua number/string/nil. On the KV (redb) variant, calling this returns a clear error directing you to download the SQLite build.

Parameters

Param	Type	Description
sql	string	The SQL SELECT statement
params	table?	Optional array of positional parameters for prepared statements (? placeholders)

Returns

Value	Type	Description
rows	array	Array of row tables with column-value pairs

Example

local rows = db_query("SELECT json FROM records WHERE job_id = ? LIMIT 5", { "my-job" })
for _, row in ipairs(rows) do
    local data = json_decode(row.json)
    log("Title: " .. data.title)
end

See Also

• db_exec - Execute INSERT/UPDATE/DELETE statements