The new Sqlite DB Query Reader doesn't support window function

[ergest]

I have a fairly simple Sqlite query that uses window functions row_number() and it works fine with the legacy Database Reader node but doesn’t work with the new DB Query Reader node.
The error I get is: Execute failed: [SQLITE_ERROR] SQL error or missing database (near "over": syntax error) See attachment
Fantasy-Premier-League Export.knwf (3.3 MB)

[mlauber71]

@ergest you can install the latest driver yourself. For H2 they will also support window functions

SQLITE and Window Functions

@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver. [image] [image] @khatuaani now you can benefit from the latest developments with H2 (and SQLite).

@tobias.koetter you could see if KNIME could update the default drivers

[ergest]

Works beautifully! Thank you.