Allow anonymous access to some rows on demand

Is there any way for me to be able to allow to create a public share url of a filtered row with read only access?

The scenario is that I have a item table and I create a custom view of this as a end user filtering on a few rows and that I own it:

SELECT * FROM item WHERE owner_id='myuserid' AND type='cats'

Then I want to make a publicly shareable url to view this. Any idea on how to do that with supabase? Usually with a nodejs backend e.g. the nodeJs would have full read access to the table and could get those elements and show them based on a "public" table or something.
Was this page helpful?