[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]mcnux[/eluser]
Quiet week, lucky you! Then I came back :-)

I'm having an issue with queries which include related tables but also use the standard where() method to query the originating model/table. The issue being no table is added to the column from the where clause and therefore the query doesn't know which table's id column to query, resulting in the error "column id is ambiguous" Here's an example of what I'm trying:

Code:

$jobs = new Job();
$jobs->where_in('id',$idArray)->include_related('location','name')->get();

// results in query:
SELECT
  jobs.*,
  locations.name AS location_name
FROM
  jobs
  LEFT OUTER JOIN locations ON jobs.location_id = locations.id
WHERE
  id in (1,2,3) // MySQL says who's id?

I'd rather not have to change my where_in to where_in('jobs.id',$idArray) as this is directly referencing the table name when I want to construct the query using model names only and let the datamapper do it's job of mapping to the correct table.

Please advise.