Can I see (...) the real SQL
If you require to see the SQL sent straight to the database (that is formatted related to your example), you'll have to use any kind of jdbc driver proxy similar P6Spy (or log4jdbc).
Alternatively, you can permit logging of the following sections (using a log4j.properties file here):
The first is equivalent to hibernate.show_sql=true, the second prints the bound parameters among other things.
For more check out