Problem
When using SQLSource, it's not clear from the documentation that parameters are for binding scalar VALUES, not for injecting entire SQL query strings.
Reproduction
Given a Python tool that returns a SQL query string:
def build_query(keywords: str) -> str:
return f"SELECT * FROM table WHERE name LIKE '%{keywords}%'"
And a SQLSource step attempting to use this query:
- type: InvokeTool
id: build_query
tool: my_tools.build_query
input_bindings:
keywords: keywords
output_bindings:
build_query_result: sql_query
- type: SQLSource
id: execute_query
connection: "awsathena+rest://..."
query: ":sql_query"
inputs:
- sql_query
outputs:
- result_id
Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## ExpectTYP## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Exant## Expected ##g t## Expected ## Expected ## Expected ## Expected ## res## Expected with parameterized VALUES only (e.g., WHERE id = :product_id).
Suggested Documentation Improvement
Add cleAdd cleAdd cleAdd cleAdd cleAdd cleAdd cleAdd cle. ✅ Correct:Add cleAdd cleAddpaAdd cleAdd cleAuesAdd cleAdd cleAdd cleAdd clngAdd cleAdd cleAdSQAdd cleAdd cleAdd clers
Problem
When using SQLSource, it's not clear from the documentation that parameters are for binding scalar VALUES, not for injecting entire SQL query strings.
Reproduction
Given a Python tool that returns a SQL query string:
And a SQLSource step attempting to use this query:
Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## ExpectTYP## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Expected ## Exant## Expected ##g t## Expected ## Expected ## Expected ## Expected ## res## Expected with parameterized VALUES only (e.g.,
WHERE id = :product_id).Suggested Documentation Improvement
Add cleAdd cleAdd cleAdd cleAdd cleAdd cleAdd cleAdd cle. ✅ Correct:Add cleAdd cleAddpaAdd cleAdd cleAuesAdd cleAdd cleAdd cleAdd clngAdd cleAdd cleAdSQAdd cleAdd cleAdd clers