JS SDK - UNION ALL

🟡javascript🟢SQL

Hello,

How do I write UNION/INTERSECT operations in JS SDK? AFAIK there's workarounds with matviews and RPC, but that would be a pain if I want to dynamic join that with another table. Or I would query two times, and have headache with pagination.

I want a specific solution like this:

  let query = supabase
    .from('Company_Offers UNION ALL Specialist_Offers')
    .select('id, name, Categories(id, name)', { count: 'exact' });

  let query = supabase
    .from('Company_Offers UNION ALL Specialist_Offers')
    .select('id, name, Categories(id, name)', { count: 'exact' });

JS SDK - UNION ALL

Similar Threads

JS SDK - UNION ALL

Similar Threads

Similar Threads

Similar Threads