Yep, this 100% is my use case (although I use Cloudflare's pages, and use supabase for storage layer). I don't even like writing js, prefer python... but it's so dang easy to use a SSG + js for dynamic content on supabase.