[Feature]: Evaluate functions with side effects

Describe the new feature

When I call some function its actually called 4 times.
That's fine for most functions, but I'm trying to work with some extension functions that have side effects (it takes a long time to execute).

I was wondering if there is some workaround to avoid that extra evaluations.

I've made an example function that logs some text to show the issue:

USER LOG
-- EXECUTING ALL IN 'SQL 1'
--
-- At line 1:
SELECT TEST()
-- Result: 1 rows returned in 63ms

APPLICATION LOG
PRAGMA foreign_keys = '1';
PRAGMA database_list;
SELECT type,name,sql,tbl_name FROM "main".sqlite_master;
PRAGMA encoding;
SAVEPOINT "RESTOREPOINT";
SELECT COUNT(*) FROM (SELECT TEST());
SELECT TEST() LIMIT 0, 49999;
ROLLBACK TO SAVEPOINT "RESTOREPOINT";
PRAGMA database_list;
SELECT type,name,sql,tbl_name FROM "main".sqlite_master;
RELEASE "RESTOREPOINT";

ERROR LOG
(0) Executing TEST()!
(0) Executing TEST()!
(0) Executing TEST()!
(0) Executing TEST()!

Does this feature exist in another product or project? Please provide a link

In sqlite cli it's called only once:

sqlite> SELECT TEST();
(0) Executing TEST()!
┌────────┐
│ TEST() │
├────────┤
│ NULL   │
└────────┘

Do you have a screenshot? Please add screenshots to help explain your idea.

No response

Commencez par reproduire l’exemple SELECT TEST() dans DB Browser for SQLite et comparez son journal d’application au comportement de sqlite CLI présenté dans l’issue. Déterminez où se produit l’évaluation répétée et définissez l’achèvement de sorte que les fonctions ayant des effets de bord ne soient évaluées que comme prévu, sans perturber l’affichage des résultats ni le traitement des requêtes.