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. List[dict]: List of rows matching the query. | int | None |