A modern programming language that makes developers happier.

kotlinlang

Hi, im trying to use room with sqlite windowing functions LAG and LEAD

from my investigations i have found that room does not support these window functions due to the version of Sqlite shipped with android
is there any way i can download and install the most recent version of sqlite into my current android application to fix this issue?

if i manage to install the most recent version of sqlite will room auto detect it, or will I have to complete addintional configuration steps for room?

we already validate w/ a more recent version of sqlite so that might already include what you want from validation perspective.
as for shipping a later version, there are some public deployments that also implements the API room needs to use it

e.g. <https://github.com/requery/sqlite-android>

if room doesn’t understand the query, you can simply ask it to skip validation for that query (not great but would be a workaround)

i got this to work by using a @RawQuery

```@RawQuery
suspend fun rawQuery(query: SupportSQLiteQuery): List&lt;PreviousNextVO&gt;```
and getting the most recent sqlite aar and adding
<@U0B98KWF4> how do you ask Room to skip validation of a particular statement?