hi, is there anyway that i can execute raw sql commands using the supabase client or do i have to use any nodejs-postgres driver for that?

You cannot do these from the client directly, but you can create postgres functions and call them via the

.rpc

method of the supabase client library.

Yes that's what I've thought, prisma has this thing,

prisma.raw

. but I understand it will raise security concerns being used at the client side. it might be difficult to create a table with fields and it's types as params of an RPC. Thanks for the help.