Delete Limit issue "parser stack overflow"

[41linea45]

DELETE FROM HISTORYWHERE ID IN (SELECT ID FROM HISTORY WHERE ID LIMIT 1 )
SQL error: parser stack overflow Time taken:2444

Hello,
Firstly thank you for amazing library.

I tried delete and limit in sql. it gives error.
Normally, this sql command works in sqlite studio.
How can i use delete and limit in sql command?
Thanks for advance.

[outcastdreamer]

I also have questions regarding this error "Parser stack overflow". What queries or operations are causing this error to occur? I believe the queries that cause this error should be mentioned under the "Limitations" section of the documentation. Also any workaround to it if possible.
Amazing library still! It has made file handling redundant in my project!