SupaBase - change behaviour of SELECT * to SELECT a,b,c

Hi there,

I try to find a way around the behaviour that the SELECT * which is used in the ootb query and actions is changed to query specific columns.

Reason: SupaBase is using Postgre. And what I found out right now (the hard way...) is that if the user is granted access to specific columns instead of all columns, we get an permission denied error when the user tries to fetch rows with SELECT * instead of SELECT specificColumns ...

So I know the granted columns because I have developed a permission pattern and I can fetch these allowed columns dynamically. But I need to being able to use that dynamically when running the SELECT.

Is the only way that we use here custom code and/or api calls?

Any idea? Is there something on the roadmap?