SQLite doesn't have SQTR as a standard function, so you would normally do this in code.
There is a way though to do this in SQL with a CTE:
strSQL = "update Table1 set xValue = (" & _
"with Guesses(FindRootOf, " & _
"guessRoot) as (" & _
"select xValue, " & _
"case when xValue...