Subqueries vs Joins when selecting across a many-to-many relationship in Postgres

About

Supabase is the Postgres development platform. Create a backend in less than 2 minutes. Start your project with a Postgres Database, Authentication, instant APIs, & realtime subscriptions. Whether you're new to development or looking to migrate existing workloads, you'll find Supabase tutorials & tips that will make your app development easier. From database migrations to query optimizations, we cover everything you need to build quickly with Supabase. Supabase provides a full Postgres database for every project with pgvector, database backups, extensions, & more. Add & manage email & password, passwordless, OAuth, & mobile logins to your project through a suite of identity providers & APIs. Kickstart your next project with templates & use our Instant APIs that do the hard work for you. We introspect your database to provide APIs instantly. No more repetitive CRUD endpoints - build your app without ever leaving the dashboard! Build in a weekend, scale to millions.