All the major SQL and a few NoSQL databases support JOIN queries. Currently, there is nothing in here to support them. Everything is queried like we're doing an ActiveRecord includes to load associated records, but I'd like to support joins:
The mapper would then look at the author attribute, see that it's a reference to another object, then set up that join. And along with #44, we need a way to indicate that in the intermediate query form.
All the major SQL and a few NoSQL databases support
JOINqueries. Currently, there is nothing in here to support them. Everything is queried like we're doing an ActiveRecordincludesto load associated records, but I'd like to support joins:The mapper would then look at the
authorattribute, see that it's a reference to another object, then set up that join. And along with #44, we need a way to indicate that in the intermediate query form.