Modern relational database features in PostgreSQL include complex queries ... refer to the database diagram, so I suggest using a graphical database client with a SQL builder.

Fortunately, there are database development tools that can generate correct SQL queries for you, often by dragging and dropping tables and fields from the schema diagram into a query diagram.

Swarm64 DA is an extension to EDB Postgres Advanced that enhances query performance by up to 20x, via: Compressed columnstore indexing Greater parallel processing Faster SQL JOIN algorithms ...