Debugging queries with symfony, doctrine and sprintf

Sometimes it is useful to see what parameters were passed to a query, using getSqlQuery we get the query with question marks and its annoying to then grab the query and play around with it... below is a quick fix for this problem, this purely a technique to save development time and you shouldn't leave var_dumps in your production code :)

var_dump(array(
 'sql_query' => sprintf(
  str_replace('?', '%s', $q->getSqlQuery()), 
      $parameter1, $parameter2, $parameter3
 )
));