Hi,
Is there any way I can gain access to the SQL NHibernate generates? No, no modifications intended :)
Thanks!

In your config file simply set the show_sql property to true

My bad :) Somewhat incorrect question.
I actually need to be able to save the SQL it generates to the database (for the sake of logging, debugging and stuff like that). I'm not sure if writing a custom Appender for log4net will help, since I need to write lots of other stuff along with the SQL.

The log4net output doesn't show the parameter values anyway

It does :)
2006-06-07 22:05:17,804 [1624] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT permission0_.ID as ID0_, permission0_.Description as Descript4_0_, permission0_.Name as Name0_, permission0_.Guid as Guid0_ FROM Permission permission0_ WHERE permission0_.ID=@p0
2006-06-07 22:05:17,804 [1624] DEBUG NHibernate.SQL [(null)] <(null)> - @p0 = '1'

That's weird, mine only shows the statement. What the ...?

All right, I found a couple of ways to get hold of SQL :)
First is to write custom Entity Persister (IEntityPersister) and retrieve SQL from IDbCommand in Dehydrate().
Second is to write a custom Batcher (IBatcher), since all operations are performed via Batcher. But there's one thing -- batcher can only be substituted at runtime using reflection (ISession has a field named batcher).

Hmmm, we'll have to try implementing IEntityPersister. Still, that seems like a hassle just to get the SQL. We "cheated" by creating a NHibernate.Hql.QueryTranslator for the given HQL text, calling queryTranslator.Compile(), and then using reflection to get at its protected SqlString property.

Request: the SQL text should be exposed as public and readonly, either throuh a separate property for .NET 1.1 or with a public getter and protected setter in .NET 2.0.

SQL text alone is not enough, unless it will explicitly contain parameters' values.