Enhance SQL function

It is suggested to add
1.ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2)
2.Upsert https://www.postgresqltutorial.com/postgresql-upsert/
3.other window function: count|max|min|lead|lag|first_value|last_value over(PARTITION BY COL1 ORDER BY COL2)
4.CONCAT_WS() GROUP BY

Is there an alternative to ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2) currently supported in alasql?

I would like to limit the number of results by a specific group while keeping the order by

hmm... even UNION does not seem to work

alasql` select entries.*
        , watched.id IS NOT NULL as watched
      from entries
      outer join watched on watched.id = entries.id and watched.ie_key = entries.ie_key
      join playlists on playlists.original_url = entries.original_url
      where entries.id not in (select distinct id from watched) and entries.original_url = "https://www.youtube.com/playlist?list=PLQhhRxYCuOXX4Ru03gUXURslatUNxk7Pm"
       order by random() limit 100
UNION ALL
select entries.*
        , watched.id IS NOT NULL as watched
      from entries
      outer join watched on watched.id = entries.id and watched.ie_key = entries.ie_key
      join playlists on playlists.original_url = entries.original_url
      where entries.id not in (select distinct id from watched) and entries.original_url = "https://www.youtube.com/watch?v=qopNCLDbD1M"
       order by random() limit 100`

The queries work fine individually but with the union all I get:

Uncaught (in promise) TypeError: this.queriesfn is undefined
    anonymous alasql.js:3
    n3 alasql.min.js:2
    n3 alasql.min.js:2
    n3 alasql.min.js:2
    n3 alasql.min.js:2
    $ alasql.min.js:2
    L alasql.min.js:2
    fromTable alasql.min.js:2
    datafn alasql.min.js:2
    r2 alasql.min.js:2
    r2 alasql.min.js:2
    r2 alasql.min.js:2
    $ alasql.min.js:2
    L alasql.min.js:2
    fromTable alasql.min.js:2
    datafn alasql.min.js:2
    r2 alasql.min.js:2
    r2 alasql.min.js:2

queriesfn is undefined Seems to be a theme for UNION (also relevant to #1264)

I have a feeling its a small fix, but hard to find where.

Findings

Fully Implemented:

✅ ROW_NUMBER() OVER (PARTITION BY col1 ORDER BY col2) - Tested in test/test1126.js
✅ CONCAT_WS(separator, col1, col2, ...) - Tested in test/test413.js

Not Implemented yet:

❌ Window functions: LEAD, LAG, FIRST_VALUE, LAST_VALUE
- Window Offset Functions (LEAD/LAG/FIRST_VALUE/LAST_VALUE) Not Implemented #2409
⚠️ COUNT/MAX/MIN OVER (PARTITION BY) - Syntax parsed but window semantics broken (returns single row instead of per-row windows)
- Window Aggregate Functions (COUNT/MAX/MIN) Not Working with PARTITION BY #2408
⚠️ UPSERT - MERGE syntax parsed (src/75merge.js) but execution not implemented
- UPSERT/MERGE Statement Not Implemented #2407

Hi, if no one is currently working on this issue, I’d love to give it a try. Could you please assign it to me? I’m curious and excited to work on this.

Happy to add you, however, please note that depending on the volume of the added code we might not include it until we have the setup for modular inclusion of functionality

Navigation Menu

Repository navigation

Enhance SQL function #1216

Findings

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Enhance SQL function #1216

Description

Activity

chapmanjacobd commented on May 31, 2022

chapmanjacobd commented on Jun 1, 2022

mathiasrw commented on Sep 25, 2022

mathiasrw commented on Dec 22, 2025

Findings

imsanupm commented on Feb 28, 2026

mathiasrw commented on Apr 1, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions