Hello, This most certainly looks like a bug to me. The same query gives a different result when using DB Browser vs the C# System.Data.SQLite.Core wrapper. The following query: ``` var sqlCmd = new SQLiteCommand("SELECT SUM(Cost * Quantity) FROM Parts", connection); var value = await sqlCmd.ExecuteScalarAsync(); ``` always returns an Int64 value, despite Cost=numeric and Quantity=integer. Even if you cast the SUM as a numeric type, you still get back an Int64 and it truncates the decimal values. The same query results in a numeric type when using something like DB Browser, and not an Int64. I can't seem to find a workaround. Can anyone else confirm this?