node-pg postgresql connections with sslmode=require

[dbauszus-glx]

Connection strings provided for a node-pg connection pool may require SSL.

For example the connection string copied from the neon dashboard requires sslmode.

Node 24+ will throw a security warning in this regard.

(node:26292) Warning: SECURITY WARNING: The SSL modes 'prefer', 'require', and 'verify-ca' are treated as aliases for 'verify-full'.
index.js:216
In the next major version (pg-connection-string v3.0.0 and pg v9.0.0), these modes will adopt standard libpq semantics, which have weaker security guarantees.
index.js:216

index.js:216
To prepare for this change:
index.js:216
- If you want the current behavior, explicitly use 'sslmode=verify-full'
index.js:216
- If you want libpq compatibility now, use 'uselibpqcompat=true&sslmode=require'
index.js:216

index.js:216
See https://www.postgresql.org/docs/current/libpq-ssl.html for libpq SSL mode definitions.
index.js:216
(Use `node --trace-warnings ...` to show where the warning was created)

Please use uselibpqcompat=true&sslmode=require as parameter for connection strings for libpq compatibility as suggested in the error message.