drizzle-kit generate doesn't run custom sql

export const customAccessTokenHook = async () => {
  await db.execute(sql`
    CREATE OR REPLACE FUNCTION public.custom_access_token_hook(event jsonb)
    RETURNS jsonb
    LANGUAGE plpgsql
    AS $$
    BEGIN
       // do stuff here
    END;
    $$;
  `);
};

export default defineConfig({
  dialect: 'postgresql',
  schemaFilter: ['public'],
  schema: './src/lib/db/schema/*',
  out: './supabase/migrations',
  dbCredentials: {
    url: process.env.DATABASE_URL || 'postgresql://postgres:postgres@127.0.0.1:54322/postgres'
  }
});