Hi , does xano support views ? like in supabase where I can create a view which combines data of 2 tables. This way I wont have to juggle between tables if i need data from both.
Here is what I am trying to do , for context.
I have a Business table where I store details of businesses
I have another table "OpenAIkeys" that store openai keys of these businesses
business.id is foreign key in this.
I want to create an endpoint which returns everything in business table and openai keys combined
so each business object will have openai key with it.
in supabase , i could create a view quickly and get this done
in xano , not sure
Should we query all businesses
then loop through each and add openai key ?