nuxt.confg.ts supabase clientOptions db schema works for useSupabaseClient() but NOT serverSupabaseClient()

[jonesisg1]

Version

@nuxtjs/supabase: v1.1.0
nuxt: v3.7.3

Steps to reproduce

Create a new schema 'myschema' in Supabase project.
Grant privs as in docs:

GRANT USAGE ON SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL TABLES IN SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL ROUTINES IN SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL SEQUENCES IN SCHEMA myschema TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON TABLES TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON ROUTINES TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON SEQUENCES TO anon, authenticated, service_role;

Add myschema to Project Settings -> API Settings -> API settings -> Exposed schemas
Create a table 'mytable' in myschema and add a row of data.
Configure your nuxt.config.ts file:

export default defineNuxtConfig({
  devtools: { enabled: true }, 
  modules: [
    '@nuxtjs/supabase'
  ],
  runtimeConfig: {
    public: {
      baseUrl: process.env.BASE_URL || 'http://localhost:3000'
    },
  },
  supabase: {
    clientOptions: {
      db: { schema: 'myschema' }
    },    
    redirectOptions: {
      login: '/',
      callback: '/confirm'
    },
  }
})

Create a server API route:

import { serverSupabaseClient } from '#supabase/server';
export default defineEventHandler(async (event) => {
  console.log('Calling client.from')
  const client = await serverSupabaseClient(event);
  const { data } = await client.from('mytable').select('mycol');
  console.log(data);
  return data;
});

Call the endpoint from your Vue page.

What is Expected?

Variable 'data' should contain the row from myschema.mytable.

What is actually happening?

Variable 'data' is always null.
When you look in the database logs you see:

[{"event_message":"relation \"public.mytable\" does not exist","metadata":[{"file":null,"host":"db-....

Other comments.

If you place the following code in the Vue page:

const client = useSupabaseClient()
const { data: data } = await useAsyncData('mydata', async () => {
  console.log('from asyncData');
  const { data } = await client.from('mytable').select('mycol')
  return data
})

The variable 'data' is populated with the row from mytable correctly.

[jonesisg1]

I have fixed this issue locally and will fork the project and attempt a pull request. (Never done one before!)