What is the preferred way of using unsupported SQL functions or clauses with Castle/NHibernate?

I modeled all of my tables and already ported most of my queries using detached criteria's. All is working very well however I'm at a point where I don't know how to advance. I ha开发者_开发问答ve a sub-query that uses Oracle's "connect by" clause. How do developers typically overcome that limitation of Castle/NHibernate?

I am using the latest version of NHibernate.

If you really need to use connect by, you can always use a SQL Query (and there's a whole chapter about it).

However, given NHibernate's usage of the Identity Map pattern, is usually more productive to just load the objects and let the relationships be established in memory.