In sf 1.0 and 1.1, SQL queries in the SQL panel of the web debug toolbar were syntax highlighted, and separated from each other by at least a blank line. Now they are all stacked together and not syntax highlighted anymore. It makes it very difficult to read the queries.
Also, Propel 1.3 uses PDO instead of Creole. That means logged SQL queries show named or question mark placeholder together with a replacement matrix.
SELECT COUNT(*)
FROM sf_blog_comment
WHERE (sf_blog_comment.SF_BLOG_POST_ID=:p1
AND sf_blog_comment.IS_MODERATED=:p2)
(:p1 = 1, :p2 = false)
I understand that this is what PDO can return, but that's a step back from what the Propel plugin used to do in sf 1.1. With Creole, the reals SQL queries appeared in the web debug toolbar, ready to be copied-and-pasted into a db engine to test the results.
SELECT COUNT(*)
FROM sf_blog_comment
WHERE (sf_blog_comment.SF_BLOG_POST_ID=1
AND sf_blog_comment.IS_MODERATED=false)
To keep sf 1.2 on par with sf 1.1 as far as Propel debugging tools are concerned, the Propel Web Debug Panel should reconstruct an executable query from a prepared statement and a list of tokens.
