工具 API

query_data

Analyze financial market data using SQL. Queries DataFrames stored via call_api's store_as parameter. Uses SQLite SQL engine — supports standard SQL including scalar subqueries, CTEs, ILIKE, window functions, and complex expressions. Special commands: 'SHOW TABLES' lists stored tables, 'DESCRIBE <table>' shows table schema, 'DROP TABLE <table>' removes a table. Tables auto-expire after 1 hour. Optionally set apply to a list of function steps to post-process query results — each step is {"function": "name", "inputs": {"param": value}, "output": "col_name"}. Use search_endpoints with scope="functions" to discover available functions.