Skip to main content

select

Select rows from a table with filtering and ordering options.

Parameters

NameDescriptionTypeDefault
table (required)Name of the table to select from.strNone
whereDictionary of conditions for the WHERE clause.dictNone
order_byColumn name to order by.strNone
order_descWhether to order in descending order. Defaults to False.boolFalse
limitMaximum number of rows to return.intNone
offsetNumber of rows to skip. List[dict]: List of rows matching the query.intNone