This seems like it would be very helpful for async Node applications allowing one to easily send all needed queries from an iteration of the event loop in one go. To achieve this currently I need to combine all the various queries I use into a single complex query (UNION ALL with an extra column identifying which of the combined queries the result is for.)
Postgres 14 added support for pipeline mode to libpq. "You can use it on old PostgreSQL versions so long as you're using a new libpq."
This seems like it would be very helpful for async Node applications allowing one to easily send all needed queries from an iteration of the event loop in one go. To achieve this currently I need to combine all the various queries I use into a single complex query (UNION ALL with an extra column identifying which of the combined queries the result is for.)