Composing in this context means that one part of your application (eg the list controller) builds part of a query (the select from) and another part (eg the fil

Composing in this context means that one part of your application (eg the list controller) builds part of a query (the select from) and another part (eg the filter controller) builds another part of the query (the where part) and yet another part of you application (the paginator) alters there where part, adds limits and offset and build another query based on the same filter conditions to calculate the total row count. All that without the different controllers knowing each others in advance. This is not possible without complicated string manipulation or building some not-sql-query-algebra. Some api like prepared statements (supported by the db itself) for building up complex queries step by step would be nice. Does something like this exist?