We are using Play SQL Base to retreive some data from Firebird DB with Generic dialect. After upgrading plugin from 2.6.x to the latest version it started to query DB like this:
FROM (%here is our initial query%) AS TARGET_TABLE LIMIT 1
and this causes the error:
There is an error in the SQL syntax: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 37, column 20 LIMIT
"LIMIT" is not generic for SQL, it shouldn't be used in this case.