The math functions that come with the core SQLite available for querying existing queries in Redash are extremely limited. For instance, I need the power function, but it isn’t available. And, since I’m using a JSON data source, to the best of my understanding, it isn’t possible to apply the power function in the initial query that pulls the data into Redash. I have to use QRDS.
Fortunately, advanced math functions are already available for SQlite depending on how it is compiled:
https://www.sqlite.org/lang_mathfunc.html
https://www.sqlite.org/contrib
It would be great to see these function made part of the standard QRDS functions available in Redash.
