base_readQuery
Execute SQL queries with optional bind parameters and persist large result sets as a table for later use, returning query results and metadata.
Instructions
Execute a SQL query via SQLAlchemy, bind parameters if provided (prepared SQL), and return the fully rendered SQL (with literals) in metadata.
Arguments: sql - SQL text, with optional bind-parameter placeholders persist - Set to True to persist the results as a table and reuse it later. Recommended for large result sets.
Returns: ResponseType: formatted response with query results + metadata (includes 'volatile_table' field in metadata if persist=True)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | ||
| persist | No |