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

# room

[Tower Guidev2]

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

[Tower Guidev2]

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?

[Tower Guidev2]

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?

[yigit]

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

[yigit]

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

[yigit]

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)

[Tower Guidev2]

i got this to work by using a @RawQuery

@RawQuery
suspend fun rawQuery(query: SupportSQLiteQuery): List<PreviousNextVO>

and getting the most recent sqlite aar and adding
@yigit how do you ask Room to skip validation of a particular statement?