JOIN Like an ORM: Foreign-Key Relations in PostgreSQL

A PostgreSQL query that navigates relations: SELECT item.name item_name, client.name client_name, manager.name manager_name, document_item.quantity FROM document_item , document(document_item) , item(