search

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.ophir.dev
MIT License
882 stars 62 forks source link

allow calling sqlpage functions on all rows returned from a database query #337

Open lovasoa opened 1 month ago

lovasoa commented 1 month ago

Currently sqlpage functions are executed before the query is sent to the database, and their output is sent to the database. To use a value from the database as input in a sqlpage function, one needs to define a variable:

set $x = (select x from y where id = 123);
select sqlpage.some_function($x);

However, the following is not possible:

select sqlpage.some_function(x) from y;

we should lift this limitation.

see https://github.com/lovasoa/SQLpage/discussions/328