On trunk as of right now:

SQLiteDialect does not properly quote table names when the table does
not have an associated schema. I'm not super familiar with
NHibernate, so maybe that's by design, but the MsSQL2005Dialect
returns "[name]" when a similar test as below is run against it.

You can add and run the following test to
Nhibernate.Test.DialectTest.SQLiteDialectFixture to verify this:

        [Test]
        public void QuotedTableNameWithoutSchemaWithSqlLite()
        {
            Table tbl = new Table();
            tbl.Name = "`name`";

            Assert.AreEqual("\"name\"", tbl.GetQualifiedName(dialect));
        }

Result of test running on current trunk:

NUnit.Framework.AssertionException: Expected string length 6 but was
5. Strings differ at index 0.
  Expected: ""name""
  But was: "name""
  -----------^

Thanks.