Logarithm function in sqlite query?

There is no built-in logarithm function; you have to define your own function.

If you're using Python, this is possible with both the pysqlite and APSW modules.