I think you need to use PHQL, or raw sql, or ORM caching.
SQL_ NO_CACHE is a MySql implementation, not a SQL definition.
I understand your point about is not a SQL definition, thank's :)
In the end, PHQL, ORM objects and such are converted to plain SQL queries. Query cache must be explicitly expressed to the MySQL server, to make this possible, needs to be apart in some kind of wrapper just for mysql support :/.
That's what I want to know, if there is any other way to tell to mysql for cache using my models....