Programmatically enable supabase queues from config

I use supabase locally (self hosted) for integration testing so its important that it reflects my prod environment closely. I used supabase hosted db in prod. It seems like the recommended way to enable it is to go into the studio self hosted UI and manually click enable. This is not a good solution for me as I frequently supabase db reset in between tests etc. Maybe I shouldn't be reseting so frequently? I want to use Supabase Queues but there are 2 main friction points with it: 1. Enable the extension is difficult to do within a migration file 2. creating the same pqmq_public interface as described in the docs requires some hacking: I'm having an issue that I cannot enable CREATE EXTENSION IF NOT EXISTS pgmq from a migration file. I get a permission error: I managed to workaround this by putting CREATE EXTENSION IF NOT EXISTS pgmq in my roles.sql file which seems to run at a higher privledge. The second problem is that the pgmq_public seems to …