drop table if exists user_roles;
drop type if exists custom_user_roles;

CREATE TYPE custom_user_roles AS ENUM ('user','approver','admin');

create table user_roles (
  id uuid references auth.users not null unique,
  role custom_user_roles not null default 'user',

  primary key (id)
);

alter table user_roles enable row level security;

create or replace function add_default_user()
  returns trigger as
$$
begin
  insert into public.user_roles(id, role) VALUES (NEW.id, 'user');
  return NEW;
end;
$$
language 'plpgsql' SECURITY DEFINER;

drop trigger if exists default_user_role on auth.users;
create trigger default_user_role after insert on auth.users execute procedure add_default_user();

sql
WITH folders as
select
  storage.foldername(name) as folders
from
  storage.objects;
folders [ 0 ] = 'avatar'
and uid() = (
  SELECT
    rooms.owner
  FROM
    rooms
  WHERE
    rooms.id:: text = folders [ 1 ]
)

CREATE OR REPLACE FUNCTION net."http_post"(

ERROR:  cannot remove parameter defaults from existing function
HINT:  Use DROP FUNCTION net.http_post(text,jsonb,jsonb,jsonb,integer) first.

pg_net

public.users

auth.users

userprofile

select
  *
from
  calculator_screens
  inner join calculator_answers answer on answer.calculator_screen = calculator_screens.id

calculator_moves

calculator_answer

calculator_screens

More than one relationship was found for calculator_screens and calculator_answers

calculator_moves

.rpc()

sql
CREATE POLICY "allow_insert"
ON "CompanySubmissions"
FOR INSERT WITH CHECK (
  auth.role() = 'anon'
);

json
{
"code":"42501",
"message":"new row violates row-level security policy for table \"CompanySubmissions\""
}

.insert

{ returning: 'minimal' }

-- # EXAMPLE TABLES
TABLE public.projects (
  id: TEXT
  name: TEXT,
)

TABLE public.sheets (
  id uuid primary key default uuid_generate_v4(),
  project_id not null references public.projects(id)

  name: TEXT,
)

-- # EXAMPLE QUERY
const { data, error } = await supabase
  .from('sheets')
  .select(

)
  .match({ "sheets.name": 'sheet_name' })