On Thu, 17 Jun 2021, Alan Gauld via Python-list wrote:
Sounds like a job for a database view. Can you modify the database schema? Could you create a view - even a temporary one just while your app is running?
Alan, Yes, created views work well with postgres. Building one for complex, multitable queries is always a good idea. Thanks, Rich -- https://mail.python.org/mailman/listinfo/python-list