Is it possible to connect custom Drizzle ORM schemas to Payload CMS for visualization purposes?

[kodermax]

Dear Payload CMS creators,

I'm interested in the integration possibilities between Drizzle ORM and Payload CMS. Specifically, I have a few questions:

Is it possible to connect custom Drizzle ORM schemas to Payload CMS for visualization purposes?

Can we interact with the same database table using both a backend built with Hono and Payload CMS? For example, if we have a 'Pages' collection, how can we ensure both systems work with the same underlying data?

Are there any examples or documentation showing how to use Drizzle ORM with PostgreSQL in the context of Payload CMS?

I've noticed that Payload 2.0 now supports PostgreSQL and uses Drizzle ORM under the hood. This is a great step forward! However, I'm looking for more detailed information on how to leverage this integration in custom setups.

Thank you for your continuous work on improving Payload CMS!"