Need a function or a way to FILTER the SQL query that was created before executing it. example if user X is logged in, add a certain Where clause (even if a group by is there or a having)

vanna-ai / vanna

🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.

https://vanna.ai/docs/

MIT License

11.04k stars 862 forks source link

Need a function or a way to FILTER the SQL query that was created before executing it. example if user X is logged in, add a certain Where clause (even if a group by is there or a having) #269

Open Ressno opened 7 months ago

Ressno commented 7 months ago

would be nice to have the ability to filter more the data depending of a user using the app. not all user can see example sales data would be nice to add WHERE clause depending who is logged on, stuff like that