These days there are other tricks you can use to turn several SQL queries into a single round-trip too, with things like JSON aggregates.

Here's an example PostgreSQL query that returns 10 rows from one table and 20 rows from another table in a single network round-trip, using JSON serialization to return the different shaped rows in one go: https://simonwillison.net/dashboard/union-json-demo/

Related trick: https://til.simonwillison.net/sqlite/related-rows-single-que...