How to get SQRT in queries from existing queries (SQLite)


Are there any ways to get SQRT in queries from existing queries?
It seems SQLite, which is used in queries from existing queries, doesn’t support SQRT and I found the extension at the bottom of this page ( might help, but I don’t know how to install it into Redash.
Or, are there any other ways?
I’m also hoping to use other math functions like STDEV, so maybe it’d be the best if I could install the math extension above.


I resolved this by myself.
I compiled the C file as below (in case of Ubuntu)

gcc -fPIC -shared extension-functions.c -o -lm

and then added the following two lines in

cursor.execute(‘select load_extension("/home/ubuntu/");’)

Please let me know if there are better ways.