Hi, i need to select all data from the DB and then rank it by points (number) naturally I'd do

const { data, error } = await supabase.from('some_table').select('*');

but what after that? Also can I run SQL commands with a SQL syntax from my application?

Hello ! This thread has been automatically created from your message in a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

4Lajf (2022-03-25)

Check out the filters here

You can't run SQL directly through the supabase library, no. The closest thing you can get is an RPC function. The filters page daviscup linked is useful for the other question, but since Supabase has TS types built in, if you're using something like VSCode, intellisense will be able to tell you what filters you can run as well as what args they accept.

I overlooked that secion of the docs, thanks for help

Thread was archived by @4Lajf. Anyone can send a message to unarchive it.