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 |