DataMapper ORM v2.0 - Input requested

[eluser]Frank Wong[/eluser]
@WanWizard, I noticed that when loading relationships, it queries everything in the child table and then it filters via code. Can you confirm this or am I messing up the relationship setup? Thanks.

Code:

$account = new Account($id);
$sql = $account->book->get_sql();
echo $sql;

Result

Code:

SELECT * FROM (`books`);

I thought the orm would do something like

Code:

SELECT * FROM (`books`) WHERE account_id = [id];