Window Functions support

[c4f3a0ce]

• MonetDBLite-Python version: 0.6.3
• Python version: 3.7.6
• Pip version: NA
• Operating System: NA

Description

It seem like MonetDBLite doesn't support Window Functions. It would be great if such feature was included in one of the upcoming releases.

What I Did

import monetdblite
monetdblite.init("/tmp/db")
monetdblite.sql("SELECT RANK(id) OVER (ORDER BY id)  FROM tables")

getting

DatabaseError                             Traceback (most recent call last)
...
DatabaseError: SQL Query Failed: ParseException:SQLparser:42000!syntax error, unexpected ID, expecting ')' in: "select rank(id"

[kutsurak]

Hi,

The next version of MonetDBLite-C library will be based on the same codebase as MonetDB itself, and it will support the same core features, including window functions. Unfortunately I have not a clear time frame for when it will be ready.

Best regards, Panos.