Since a couple of years ago, SQLite has been enriched with a bunch of new math functions not existing in previous versions: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi.
Examples: In SQLite version 3.39.4 2022-09-29 15:55:41 we can invoke:
sqlite> select pi();
sqlite> select power(2, 3);
sqlite> select floor(2.35);
Package Database[SQLite] in Maple 2022.2 does not recognize these functions.
In oldest versions of Sqlite3 we were able to add these functions after loading an external extension with sqlite3 api function load_extension() (see https://sqlite.org/contrib/download/extension-functions.c), but his option is blocked in Maple:
dbName := "d:/sq3_maple/etc.db":
sq3Extension := "d:/sq3_maple/extensions.sq3":
[Attach, Bind, ClearBindings, Close, ColumnCount, ColumnNames,
Execute, Fetch, FetchAll, FetchRow, Finalize, Open, Opened,
Prepare, RESULT_BUSY, RESULT_DONE, RESULT_ROW, Reset, Step]
conn := Open(dbName):
Execute(conn, sprintf("SELECT load_extension('%s')", sq3Extension));
Error, (in Database:-SQLite:-Execute) not authorized
Am I missing something? Any way to add these functions to SQLite in current version of Maple?
Thanks in advance.
PS: SQLite is updated in Mathematica 13.1