SQLite: return Long instead of data class in SUM

[MJegorovas]

SQLite: return Long instead of data class in SUM

[griffio]

🤔 I think this is currently by design - a nullable result generates a table interface
see #3945

Even though the column size is NOT NULL the result of SUM() is considered nullable

sqldelight/sqldelight-compiler/src/main/kotlin/app/cash/sqldelight/core/lang/util/ExprUtil.kt

Lines 106 to 113 in 5606c7e

	* sum's output is always nullable because it returns NULL for an input that's empty or only contains NULLs.
	*
	* https://www.sqlite.org/lang_aggfunc.html#sumunc
	* >>> The result of sum() is an integer value if all non-NULL inputs are integers. If any input to sum() is neither
	* >>> an integer or a NULL then sum() returns a floating point value which might be an approximation to the true sum.
	*
	*/
	"sum" -> {

e.g for example, using ROUND() would return Long directly

[MJegorovas]

Bummer, but the reason makes sense. Thanks!