DataMapper ORM v2.0 - Input requested

[eluser]Frank Wong[/eluser]
After monitoring the mysql logs, I realized that there is a discrepancy between get() and get_sql() from my previous example.

Code:

$account = new Account_dm($id);
$account->book_dm->get();

will execute (witnessed from mysql logs)

Code:

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

while

Code:

$account = new Account_dm($id);
$sql = $account->book_dm->get_sql();
echo $sql;

outputs

Code:

SELECT * FROM (`books`);

Objects relationships were not changed between the two tests.