Sqlite-net linq GroupBy cannot be translated

I am using Xamarin c# linq with sqlite-net pcl (https://github.com/praeclarum/sqlite-net). I found that all my linq groupby cannot be properly translated into SQL. Linq translates the Where clause but not Group By.

In the following example, the fields used in Transaction:

AccountId: int
Amount: double
ICategoryId: int

All these query formats result in SQL without Group By:

select * from "Transaction" where ("DateWithoutTime" <= ?)

var accountBalances1 = _dataService.Connection.Table<Transaction>()
    .Where(r => r.DateWithoutTime <= displayDuration.DurationEnd)
    .GroupBy(r => r.AccountId)
    .Select(g => new
    {
        Id = g.Key,
        Balance = g.Sum(b => b.Amount)
    })
    .ToList();

var accountBalances2 = _dataService.Connection.Table<Transaction>()
   .Where(r => r.DateWithoutTime <= displayDuration.DurationEnd)
   .GroupBy(r => r.AccountId,
    (key, g) => new
    {
        Id = key,
        Balance = g.Sum(b => b.Amount),
    })
    .ToList();

var accountBalances3 = (from t in _dataService.Connection.Table<Transaction>()
                        where t.DateWithoutTime <= displayDuration.DurationEnd
                        group t by t.AccountId
                        into g
                        select new { g.Key, Balance = g.Sum(g => g.Amount) })
                       .ToList();

To clarify it has nothing to do with double data type, I tried another group by with int data type only:

var maxIECategoryId = _dataService.Connection.Table<Transaction>()
   .Where(r => r.DateWithoutTime <= displayDuration.DurationEnd)
   .GroupBy(r => r.AccountId,
    (key, g) => new
    {
        Id = key,
        IECategoryId = g.Max(b => b.IECategoryId)
    })
    .ToList();

Similarly, the generated sql does not have group by.

All group by are processed locally. Is there any trick to write a linq group by that can be processed on the server service? or it is a limitation of this implementation of sqlite orm?

Thanks,

Nick