I would like to implement application level multi-tenancy in Retool.
For that I have a single database with all the data of all the tenants in it, so if I want to query data of a single tenant, I have to specify a WHERE clause in the query. (E.G: WHERE "tenant"='foo)
Now of course I wouldn't want to modify each query every time a new tenant is added, so
is there any way to allow a user to get data from a single specific tenant based on its user properties?