Find answers from the community

Updated 10 months ago

Is there any way with text-to-sql that

Is there any way with text-to-sql that once the AI creates the query, BEFORE running it to manipulate it?

i try to add to context. where clause it works but not often

3 comments

jjerryjliu0

if you want an out of the box component, you can use NLSQLRetriever with sql_only=True

jjerryjliu0

if you want to build from scratch check out our text-to-sql: https://docs.llamaindex.ai/en/stable/examples/pipeline/query_pipeline_sql.html#advanced-capability-1-text-to-sql-with-query-time-table-retrieval

MMeow Meow

but you mean that i could lets say add a where clause if a specific user is logged in my streamlit app?

the problem i have is salesmen should only have access to their own sales.. so i was thinking do always add a where clause

but its the same sql table

Add a reply