SQLite Forum

Ask for new feature: a pre-decoder mechanism for 'variables' and 'stdev' ?
Login
Would it be an option to have a pre-decoder stage in SQLite, that would reduce the workarounding to manage 'stddev' and 'variables' ?

- standard deviation:
  . "stdev(x)" math function is manually workarounded by replacing it by  "sqrt((sum(x * x) -2* sum(x) * avg(x) + avg(x) * avg(x) * count( * ))/count( * ))"

- "variables": methods like the one describe in Stackoverflow seems also to be a candidate for a pre-decoder https://stackoverflow.com/questions/7739444/declare-variable-in-sqlite-and-use-it/14574227#14574227

Sorry if this suggestion has already been made 42 times.