Enhance SQL function

[cmdares]

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

[chapmanjacobd]

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

[chapmanjacobd]

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

[mathiasrw]

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.