PgBouncer: The one with prepared statements

Neon now supports PgBouncer 1.22.0, which increases query throughput by up to 250% and includes support for DEALLOCATE ALL, DISCARD ALL, and protocol-level prepared statements. Prepared statements in Postgres allow you to create an SQL query once and execute it multiple times with different parameters, improving performance and security. PgBouncer is a lightweight connection pooler that helps manage and maintain a pool of database connections to overcome Postgres' connection limitations. Leveraging prepared statements can significantly boost your Postgres query performance and add a layer of security against potential SQL injection attacks when using pooled connections.