Postgres set session variables

[svetozar02]

We are planning to use DB row level security to ensure that the user only gets access to rows they are allowed to. This means that before each SQL is executed we need to set session variables that are specific to the user that is executing that query.

Any idea on how this can be accomplished?

Should we call https://vanna.ai/docs/base/#vanna.base.base.VannaBase.get_sql_prompt to get SQL and then just execute it however we want to? Bascially, we wouldn't use vanna's https://vanna.ai/docs/base/#vanna.base.base.VannaBase.run_sql