Help this noob see the light: how do I handle super dynamic queries in an ORM?
E.g. I have nodes that can be listed and sorted in various ways. That might mean having to join and/or select on additional tables (taxonomies, tags, sources, auhtors). I have a lot of code to generate exactly the query I need for any given listing, but how do I do that without string concenation? Make a dedicated query for each permutation of additional tables I need or don't need?
I'm not so much looking for an explanation in your own words, but just a point on what to search for, or maybe some articles that skip right to such "advanced" stuff.
E.g. I have nodes that can be listed and sorted in various ways. That might mean having to join and/or select on additional tables (taxonomies, tags, sources, auhtors). I have a lot of code to generate exactly the query I need for any given listing, but how do I do that without string concenation? Make a dedicated query for each permutation of additional tables I need or don't need?
I'm not so much looking for an explanation in your own words, but just a point on what to search for, or maybe some articles that skip right to such "advanced" stuff.