We have a very complex security model that is enforced via UDFs. Therefore we never do a "SELECT * FROM clients" it is always "SELECT * FROM secure_clients( CURRENT_USERS_ID)". I'm curious if this can be accomplished via hibernate? I realize I can call arbitrary SQL via named queries, but can hibernate be made to use these secure UDFs directly? We specifically would like to use the criteria API because of it's incredibly flexibility.