How to make a lot of SQL queries to the result of selecting one?

Question

PostgreSQL

Actually, we need several queries that minimally filter data from one large query. Sending it to the database with every request is pointless, VIEW simply encapsulates the code and runs the request in the same way when it is applied. There is no desire to write crutches at the application level. What can be done and is it worth bothering with it?

Answer 1

save it to a temp table and use it as many times as you like until the connection is closed

Answer 2

Maybe MATERIALIZED VIEW will do