Hello.
What version of H2 do you use?
H2 incorrectly accepts DELETE without FROM in all modes except MySQL
compatibility mode since version 1.4.197 I guess.
This is caused by incorrect implementation of feature request 585 for MySQL
compatibility:
I have a 3rd-party application that supports Oracle and I wanted to test it
with h2.
It errors out on DELETE WHERE ... because H2 requires the FROM
keyword. Weird construction as I didn't know but Oracle, MSSQL and maybe
others have the FROM as optional.
Hence the request to make it optional