is it possible to predict recall in pure sql?

[LazerJesus]

the title says it all.
is it possible to predict recall in pure sql?

my usecase is that i'd like to maintain a column recallProbabilityNow and update that every few minutes.
of course, i can just load all the rows and do the compute in python/js, but it would be cool (and fast, i guess) to run this inside the db.

[fasiha]

@LazerJesus which version are we talking about? (I think the answer is going to be "not really" but depending on which version you have different options 😅)

[LazerJesus]

i am on v2