how to order by multiple columns in supabase?

Question

How can I order by publication, then by title in supabase?

This is wrong:

.order('publicationDate', { ascending: false }, 'title', { ascending: true });

If I make them separate lines, the 2nd one overrides the first.

Answer 1

According to the comment in the source code of @supabase/postgres-js package the only way to order by multiple columns is by using .order method multiple times.