[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

まず DB Browser for SQLite で SELECT TEST() の例を再現し、そのアプリケーションログを、issue に示されている sqlite CLI の動作と比較します。評価が繰り返される箇所を特定し、副作用のある関数が意図された場合にのみ評価され、結果表示やクエリ処理を壊さないことを完了条件とします。