I've been using Scala for about 6 months, but just getting into the Lift framework. In the Lift docs, it is mentioned that although the default Mapper stuff is provided, one can use any ORM (or similar).
Are there any good examples (uncommented source is OK) of using an alternate ORM with Lift? I'm interested in using ScalaQuery, but am open to suggestions. My only requirement is that the lib has to support MSSQL. From what I've seen, this boils down to using the JTDS JDBC driver and you're off to the races.
If you want to use an ORM in Lift other than Mapper, I would suggest checking out SquerylRecord. This should be a good starting point: http://www.assembla.com/spaces/liftweb/wiki/Squeryl
I wouldn't really consider ScalaQuery an ORM, but rather a Scala DSL for SQL queries. However, I think it's a really nice option if you don't need an ORM. Also check out the work being done with Scala Integrated Query: http://days2011.scala-lang.org/node/138/279. I don't think it's ready for production use yet though.