Debugging errors in Lightspeed-controlled objects

We found two situations where Lightspeed cannot write data to database (SQLite) and it is very hard to debug/find:

1. There's a property with empty getter/setter, i.e.:
   
   property MyProperty { get; set; }
   
   In this case a compiler generates a hidden field, which is not [Transient] and Lightspeed generates incorrect SQL commands.
2. There's a field named 'Index'. SQLite doesn't allow for such field as it's a keyword: http://sqlite.org/lang_keywords.html

In both cases errors are very hard to find, since we cannot see the incorrect SQL command (in SQLite). The exception is as follows (for 2nd case):

System.Data.SQLite.SQLiteException was unhandled by user code
  Message=SQLite error
near "index": syntax error
  Source=System.Data.SQLite
  ErrorCode=-2147467259
  StackTrace:
       in System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
       in System.Data.SQLite.SQLiteCommand.BuildNextCommand()
       in System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
       in System.Data.SQLite.SQLiteDataReader.NextResult()
       in System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
       in System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
       in System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
       in System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       in ...€()
       in ..€(IUnitOfWork , IDbCommand ,  )
       in ..€(IUnitOfWork , IDbCommand )
       in ...ctor(IUnitOfWork , IEnumerable`1 )
       in Mindscape.LightSpeed.Data.DataProviderAdapter.(IUnitOfWork , IEnumerable`1 , ProviderOptions )
       in ..€(TypeModel , Query , IList )
       in ..€(UnitOfWorkBase , TypeModel , Query , IList )
       in ..€(Query , TypeModel , IList )
       in ..€(Query , IList )
       in Mindscape.LightSpeed.UnitOfWork.Find(Query query, IList results)
       in Mindscape.LightSpeed.UnitOfWorkBase.Find(Query query)
       in Mindscape.LightSpeed.Entity.LoadCollection(IEntityCollection , Entity )
       in Mindscape.LightSpeed.Entity.Get[TEntity](EntityCollection`1 entityCollection)
       [... our code ...]

It would be great if Lightspeed caught such exception and thrown an aggregate exception showing the original exception with its stack trace, but also showing the SQL command.

You can use LightSpeedContext.Logger to view the generated SQL.  This should work even if the SQL itself results in an error.  See Help Topics > LightSpeed > Logging in the docs for more info.