Debugging queries

To get a more accurate representation of the SQL statement pass the parameters into the getSql() method:

$sql = $query->getSql($query->getParams());
/*
SELECT 
    `movies`.`title`,`movies`.`year`
FROM `movies`
WHERE 
    `movies`.`title`='The Lego Movie'
*/

You may also call the debug() method which will also output the current SQL statement but also accepts a boolean flag which if true will halt execution after outputting the statement:

$sql = $query->select('*')->from('movies')->where('title', 'The Lego Movie')->debug(true);
/*
Query debug:
SELECT * FROM `movies` WHERE `movies`.`title`='The Lego Movie'
// execution stops as true was passed to debug()
*/