select

Select rows from a table with filtering and ordering options.

Parameters

Name	Description	Type	Default
table (required)	Name of the table to select from.	str	None
where	Dictionary of conditions for the WHERE clause.	dict	None
order_by	Column name to order by.	str	None
order_desc	Whether to order in descending order. Defaults to False.	bool	False
limit	Maximum number of rows to return.	int	None
offset	Number of rows to skip.	int	None

Return Value

List[Dict[str, Any]]