Support the pg_temporal extensions

[MihaiBojin]

Summary

This is a request to support the pg_temporal extension.

Goal: Enable more accurate date/time support on database(s) by using the Temporal API that will be coming to JavaScript's "standard library" (see https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Temporal for details).

pg_temporal is a very simple Postgres extension that can store, read, write, and compare ZonedDateTime objects.

The repository for the extension is available here: https://github.com/Wundero/pg_temporal.
Installation instructions are available in the repo's README; further details can be provided on request.

References

• Manual: https://neon.tech/docs/extensions/pg-extensions#request-extension-support
• Original request: https://neon.zendesk.com/agent/tickets/5339
• Slack thread: https://neondb.slack.com/archives/C04DGM6SMTM/p1740531689179539