rows

rows(cols=["*"], conditions="")

Fetches rows with optional WHERE filtering.

Parameters

cols : list[str], optional

Columns to select. Default ["*"].

conditions : str, optional

SQL WHERE clause body (without "WHERE"). Default "".

Returns

list

Rows matching the conditions as sqlite3.Row objects. Returns all rows when conditions is empty.