Support for AWS Aurora Serverless V2's Data API

[DriesCruyskens]

It is currently only possible to use a database connection string in the payload config:

import { postgresAdapter } from "@payloadcms/db-postgres";
import { buildConfig } from "payload";

export default buildConfig({
  db: postgresAdapter({
    pool: {
      connectionString: "<db connection string>" ,
    },
  }),
});

To support the Aurora Data API, drizzle initialises the driver using different config. Drizzle already has support for this (https://orm.drizzle.team/docs/connect-aws-data-api-pg)

import { drizzle } from 'drizzle-orm/aws-data-api-pg';

// These three properties are required. You can also specify
// any property from the RDSDataClient type inside the connection object.
const db = drizzle({ connection: {
  database: process.env['DATABASE']!,
  secretArn: process.env['SECRET_ARN']!,
  resourceArn: process.env['RESOURCE_ARN']!,
  }
});

So ideally it should be possible to also configure payload's postgresAdapter this way:

import { postgresAdapter } from "@payloadcms/db-postgres";
import { buildConfig } from "payload";

export default buildConfig({
  db: postgresAdapter({
     // Concept code
     connection: {
        database: process.env['DATABASE']!,
        secretArn: process.env['SECRET_ARN']!,
        resourceArn: process.env['RESOURCE_ARN']!,
      }
  }),
});