Yes, I remember using that in PHP, very handy before sqlite JSON support, since it also worked with aggregate functions.

https://www.php.net/manual/en/sqlite3.createfunction.php