I've been studying NHibernate for about 3 weeks. I've gotten it to attempt to talk to my database (JBase), however at this point I'm truly stuck. See, NHibernate uses these features that are not supported by my provider (MV.net):
Alias
Joins
Schema modifications
Returning data from more than one table
Any kind of sql function like avg, count, etc.

MV.net has implemented only the tiniest piece of SQL syntax.

That said, is there any way to get NHibernate not to use those features? I've been going over the source, and the use of aliases seems to be very prevalent and not restricted to something like the Dialect class.

P.S. I like all the features of NHibernate, and dread re-implementing even 1/5 of them myself. For instance:
-Lazy Fetching
-Eager Fetching
-Uniqueness/caching
-Object Mapping