Implement LET clause (like in OrientDB) #210

Activity

1. agershun

   added

   ! Feature request

   on May 20, 2015
2. agershun commented on May 20, 2015

   

   agershun

   on May 20, 2015

   MemberAuthor

   More actions

   One more crazy idea to extend SQL: I am thinking about two different operators: LET and BEGIN (like in the question from StackOverflow).

   LET will work before WHERE (wherefn()) and BEGIN will work right before or right after SELECT(selectfn()/groupfn()) like:

       SET @c = 0;
       SELECT a, @b, @c 
           FROM one 
           LET @b = a*a          // internal variable only for current line
           WHERE @b > 10 
           BEGIN SET @c = @c + a END;  // own accumulator for selected lines

   or call external procedure for each selected line:

       alasql.fn.myfn = function (r) {
             alasql.vars.b = r.default.a*r.default.a
       };
       alasql('SELECT a, @b FROM one LET myfn() WHERE @b > 10 ');
   
3. agershun

   added

   Regarding: OrientDB

   on May 20, 2015
4. agershun

   added this to the OrientDBThis milestone has been deleted milestone on May 21, 2015
5. mathiasrw

   added

   Related to: SQL compliance

   on Mar 22, 2016
6. mathiasrw

   removed this from the OrientDBThis milestone has been deleted milestone on Nov 20, 2025
7. mathiasrw

   assigned

   Copilot

   and

   mathiasrw

   on Aug 25, 2026
8. Copilot

   linked a pull request that will close this issue[WIP] Implement LET clause similar to OrientDB #2535on Aug 25, 2026