3 ms·
The feature to register arbitrary Python functions as scalar functions within SQL queries is pretty insane. Writing custom functions to manipulate data in ways
by noobcoder 3y ago
The feature to register arbitrary Python functions as scalar functions within SQL queries is pretty insane. Writing custom functions to manipulate data in ways that aren't possible with SQL, basically without fetching all of it at once in memory and then applying. I hope thats the case
- tored 3y agoSQLite has similar functionality. e.g PHP https://www.php.net/manual/en/sqlite3.createfunction.php https://www.php.net/manual/en/sqlite3.createfunction.php https://www.sqlite.org/appfunc.html https://www.sqlite.org/appfunc.html